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
Pl Sql Interview Questions
294 pl sql interview questions shared by candidates
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
Interview questions: About cursors, functions, index, packages etc.
How to create a compound trigger?
Viewing 211 - 220 interview questions
See Interview Questions for Similar Jobs
Application Development Senior AnalystBi DeveloperOracle DeveloperOracle Applications Database AdministratorSenior Sap DeveloperSap Basis SpecialistFunctional AnalystSenior Oracle Applicaties Technisch ConsultantOracle Applicaties Database AdministratorSenior Bi ConsultantSenior Sap Abap DeveloperSap Basis AnalystIct Business ConsultantApplication Development ConsultantSap Abap Developer Technical LeadSenior Technology ArchitectApplication Development AnalystBi Manager