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.
trig,procedure and function,delete and drop
A lot of programs to be written
PLSQL related questions will be asked
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.
basic plsql question, programs with multiple option , answer may be 2 or 3 also.
Over loading in PLSQL
Mutation of triggers. How to avoid this.
Ja trabalha na area a quanto tempo?
Viewing 81 - 90 interview questions