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
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 .
General Oracle questions
you can visit https://nikloadian.blogspot.com/ site and look for question over there.
Viewing 691 - 700 interview questions