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
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.
queries,programs.....
Query and project .... about the client
What weaknesses do you have?
All were regular interviews question like ...User of commit on trigger or exception,
Logfile sync, wait events, scattered vs sequential read and when to be concerned, heterogenous DB migration, liquibase, jenkins pipelines for databases, git webhooks
Viewing 181 - 190 interview questions