Performance tuning SQL queries
Pl Sql Developer Interview Questions
253 pl sql developer interview questions shared by candidates
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
Describe how you went above and beyond at your previous company?
Viewing 181 - 190 interview questions