Questions on 1 Plsql packages,function ,procedures and their differnces. 2 Db tables and thierJoins types. 3 Db scheduler Jobs , db links, PLSQL Db Objects such as Indexes ,Triggers,Cursors amd thier types. 4. Bulk collect and types of collections
Plsql Developer Interview Questions
297 plsql developer interview questions shared by candidates
Normal SQL and PLSQL Question .
Self intro and asked some basic questions on sql and PLSQL
About project, performance tuning and few plsql topics.
Tell me about your experience
: 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
Sql query to remove duplicate. Query to convert a given sentence into multiple rows using space as delimiter. Usage of cursor and its implementation
MCQ of PL/SQL and SQL questions
Advanced PLSQL questions and SQL related basic questions
Viewing 211 - 220 interview questions