About project, performance tuning and few plsql topics.
Oracle Plsql Developer Interview Questions
169 oracle plsql developer interview questions shared by candidates
: 1.Tell me about ur self. 2.what are all new things you learned last one year. 3. What is meatrialized view. 4.Diff b/w partition table and index. 5.write function to calculate square root, cube root with two parameter. 6.How to delete dupilicate records. 7.Difficulties faced in your project. 8.indexes 1.joins. 2.Joins scenario question. 3.join trouble shooting in query. 4.how natural join works. 5.Table partition. 6.diff procedure and function. 7.adv of packages. 8.cursor. 9.cursor attributes 10.Exception handling. 11.rxample for predefined exception. 12.Triggers 13.procedurr vs trigger 14 . Indexes 15. Write procedure for 1 to 100 addition 1What is constraints 2.Joins and it’s types 3.How will you debug your code 4.Write a procedure that will give sum of 1-10 numbers 5.tell me about your current project 6.can we use packages on procedures and functions
Basic google interview questions from all websites
MCQ of PL/SQL and SQL questions
Advanced PLSQL questions and SQL related basic questions
Trigger, view, procedure, function, joins
Most of the questions are from joins & its types. About object creation with syntax and examples
what is the difference between function and procedure?
Medium
Basic questions that are available on internet were asked, like TRUNCATE and DELETE difference.
Viewing 121 - 130 interview questions
See Interview Questions for Similar Jobs
Oracle Pl Sql DeveloperOracle Apps DbaOracle Applications Database AdministratorSenior Oracle Pl Sql DeveloperSenior Oracle Applications Database AdministratorData Stage DeveloperOracle Applications DeveloperSenior Oracle Pl Sql OntwikkelaarPlsql DeveloperSql DeveloperSenior Data Stage DeveloperSenior Oracle Database AdministratorOracle Database DeveloperSenior Pl Sql DeveloperOracle Pl SqlSenior Oracle Applications DeveloperOracle Apex DeveloperOracle Applicaties Database Administrator