Skip to contentSkip to footer

Oracle Plsql Developer Interview Questions

Salaries
Interviews

165 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
avatar

Oracle PlSql Developer

Interviewed at Q2 Software

3.6★
Aug 10, 2023

: 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

Round 1: Technical round with 3 panel members. Questions are on basics like packages, triggers, views, procedures and functions. Round 2: Coding round 7 questions in 1 hour. The coding round will be on Notepad and will be mostly SQL queries and writing code related to functions and bulk collections
avatar

Oracle PlSql Developer

Interviewed at Tyler Technologies

3.6★
Aug 12, 2024

Round 1: Technical round with 3 panel members. Questions are on basics like packages, triggers, views, procedures and functions. Round 2: Coding round 7 questions in 1 hour. The coding round will be on Notepad and will be mostly SQL queries and writing code related to functions and bulk collections

Viewing 141 - 150 interview questions

Glassdoor has 165 interview questions and reports from Oracle plsql developer interviews. Prepare for your interview. Get hired. Love your job.