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.
Delete duplicate records from table
Records type , index , query tuning
Tell me about yourself and work experience
Generally, they asked about the production side.
Online personality assessment
Difference between DDL and DML?
Write one sample query related to joins and sub query
difficult questions
triggers,functions, RIB basics,2nd highest value from a table, types
Viewing 51 - 60 interview questions