How to resolve gap in dataguard?
Oracle Developer Interview Questions
1,915 oracle developer interview questions shared by candidates
Write proc with collection? Difference between pk and unique key and questions based on them. Questions related to packages, procedures and functions eg can function return more than 1 value etc. Most of the questions from collections - nested table. How to use trim and extend? Ask to write a procedure and gave scenerios to solve using collections. Questions on performance tuning.
What is Oracle apex and architecture
trig,procedure and function,delete and drop
DWH theory , oracle issues and Informatica Power Center.
Company outlook and expections from new hires
Questions on performance tuning
what is nvl; what is substring; what is joins, what is pseudocolumn, what is cursor, how to get the dense rank for table.
About yourself
What is top rated option to recover OCR .
Viewing 691 - 700 interview questions