Skip to contentSkip to footer

Plsql Developer Interview Questions

Salaries
Interviews

295 plsql developer interview questions shared by candidates

"What are the differences between a procedure and a function in PL/SQL?" "Write a trigger that prevents deletion of records from the employee table on weekends." "Explain the concept of a mutating table and how it can affect triggers." "How do you handle errors in PL/SQL, and what are some best practices for error logging?" "What are bind variables, and how do they improve performance?" "What is the difference between an implicit and explicit cursor?" "How do you combine two tables with differing data and columns without using joins?" (Answer: You can't) "What is GROUP BY, and how is it used in SQL?"
avatar

Plsql Developer

Interviewed at Tata Consultancy Services

3.5★
Jun 27, 2025

"What are the differences between a procedure and a function in PL/SQL?" "Write a trigger that prevents deletion of records from the employee table on weekends." "Explain the concept of a mutating table and how it can affect triggers." "How do you handle errors in PL/SQL, and what are some best practices for error logging?" "What are bind variables, and how do they improve performance?" "What is the difference between an implicit and explicit cursor?" "How do you combine two tables with differing data and columns without using joins?" (Answer: You can't) "What is GROUP BY, and how is it used in SQL?"

1. sequence like 5,7,9 syntax 2. dual table rows and cols 3. substr 4. instr 5. delete duplicate records in table 6. better way of writing select distinct cls from table 7. union, minus, intersect 8. queries using join of 2 table 9. using analytical fn to find product which had increasing sales 10. pick users whose last name between h% and P% 11. transpose cols to rows in sql 12. union first table all rec, second table matching rec (different structure) 13. using group by + having clause in query
avatar

Plsql Developer

Interviewed at IHS Markit

3.7★
Sep 5, 2018

1. sequence like 5,7,9 syntax 2. dual table rows and cols 3. substr 4. instr 5. delete duplicate records in table 6. better way of writing select distinct cls from table 7. union, minus, intersect 8. queries using join of 2 table 9. using analytical fn to find product which had increasing sales 10. pick users whose last name between h% and P% 11. transpose cols to rows in sql 12. union first table all rec, second table matching rec (different structure) 13. using group by + having clause in query

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.7★
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 271 - 280 interview questions

Glassdoor has 295 interview questions and reports from Plsql developer interviews. Prepare for your interview. Get hired. Love your job.