Oracle Software Engineer Interview Questions

Oracle PlSql Developer

Interviewed at Infosys

3.6★

Oct 12, 2019

cursor types

Oracle PlSql Developer

Interviewed at Infosys

3.6★

Oct 12, 2019

Tables Partition ,indexing

Oracle PlSql Developer

Interviewed at Infosys

3.6★

Oct 12, 2019

joins based output

Oracle PlSql Developer

Interviewed at Infosys

3.6★

Apr 15, 2024

General plsql questions Performance tunning Project work experience

Oracle PlSql Developer

Interviewed at Decimal Technologies

3.2★

Dec 23, 2020

Basic questions that are available on internet were asked, like TRUNCATE and DELETE difference.

Oracle Developer

Interviewed at Exela Technologies

4.1★

Apr 5, 2019

asked to write sql queries and asked "what is" questions on plsql

Oracle Developer

Interviewed at HCLTech

3.5★

Dec 25, 2016

Triggers, type of trigger, Package... only specification enough , body required? Which is mandatory? If specification has 2 procedure and 2 functions and body doesn't have one function among them will it error ? Difference between procedure and package? What's a sequence ? Select seq.curval, seq.nextval from dual; - what will be the output of this query if it is a fresh sequence? Types of indexes? Views... can DML be performed in complex views? Example of implicit cursor ? What are cursors? Keys- primary , unique, composite ? Cursor attributes.. can we use cursor attributes in implicit cursor ? Reference cursor? Where can you find the list of views? What are Trigger event ? Materialized view? How materialized view is refreshed ? What is clustered index? Btree index?

Oracle PlSql Developer

Interviewed at HCLTech

3.5★

Sep 17, 2025

Join queries and normalisation , familiarity with other databases.

Oracle PL/SQL Developer

Interviewed at Randstad

3.6★

May 10, 2020

what is cursor?

Oracle Developer

Interviewed at Cognizant

3.5★

Oct 1, 2012

At one point he said he knows people sit in front of the computer and try to answer the technical questions. I felt mad at that knucklehead.