They will ask you about random pl/sql queries and simple question like group by, having clause and indexing etc.
Senior Pl Sql Developer Interview Questions
297 senior pl sql developer interview questions shared by candidates
Performance tuning SQL queries
Normalization and its types.Trigger and its types.diff bet Procedure and Function.Constraints.Use of Primary key and Foreign key.some Real time example for above concepts
I was so good in my subject.So that i didn't get any unexpected questions.
Questions include discussion on Performance tuning, asked to write a stored procedure, cursor syntax.
Logical reasoning
How to optimize cursors?
In Technical they have asked about basic and some advanced questions and later they ask for previous Project's all related information about u r previous company
Index scanning methods, Partitions, External Tables, SQL loader, Dynamic SQLs, and some scenerio based Qs
Plsql - collections, bulk collect SQL -truncate function with dates, logical sql queries Data base modeling Performance tuning
Viewing 211 - 220 interview questions