Oracle Database Developer Interview Questions

617 oracle database developer interview questions shared by candidates

He started out by saying this would be a conversation, not an interview. We spent about 40 minutes talking at a general level about bank, the job and him. Spent about 10 minutes discussing my background. We touched on the importance of prayer to him, and two other team leads that report to him and their roles ant outlook.
avatar

Database Team Lead - Oracle

Interviewed at M&T Bank

3.3
Feb 23, 2015

He started out by saying this would be a conversation, not an interview. We spent about 40 minutes talking at a general level about bank, the job and him. Spent about 10 minutes discussing my background. We touched on the importance of prayer to him, and two other team leads that report to him and their roles ant outlook.

1. Different between Index Full Scan and Index Fast Full Scan? 2. How do joins work in an SQL and how do they impact the execution plan? 3. What are ITLs and why do you use them? 4. How to handle heavy concurrent environment in oracle? What architecting solutions can you provide to achieve exceedingly good performance? 5. How many oracle wait events do you know and how to resolve each of them? 6. Most recent Oracle related admin/performance issues that you faced and how did you resolve them?
avatar

Oracle Database Administrator

Interviewed at Amazon

3.5
Jan 31, 2015

1. Different between Index Full Scan and Index Fast Full Scan? 2. How do joins work in an SQL and how do they impact the execution plan? 3. What are ITLs and why do you use them? 4. How to handle heavy concurrent environment in oracle? What architecting solutions can you provide to achieve exceedingly good performance? 5. How many oracle wait events do you know and how to resolve each of them? 6. Most recent Oracle related admin/performance issues that you faced and how did you resolve them?

Viewing 101 - 110 interview questions

Glassdoor has 617 interview questions and reports from Oracle database developer interviews. Prepare for your interview. Get hired. Love your job.