PL/SQL Interview Questions

What is the difference between syntax error and runtime error? A syntax error can be easily detected by a PL/SQL compiler. For example: incorrect spelling etc. while, a runtime error is handled with the help of exception-handling section in a PL/SQL block. For example: SELECT INTO statement, which does not return any rows. How to … Read more

What is the difference between execution of triggers and stored procedures? A trigger is automatically executed without any action required by the user, while, a stored procedure is explicitly invoked by the user. What are the cursor attributes used in PL/SQL? %ISOPEN: it checks whether the cursor is open or not. %ROWCOUNT: returns the number of rows … Read more

What will you get by the cursor attribute SQL%ROWCOUNT? The cursor attribute SQL%ROWCOUNT will return the number of rows that are processed by a SQL statement. What is the maximum number of triggers, you can apply on a single table? 12 triggers. How many types of triggers exist in PL/SQL? There are 12 types of … Read more

Explain the Rollback statement? The Rollback statement is issued when the transaction ends. Following conditions are true for a Rollback statement: The work done in a transition is undone as if it was never issued. All locks acquired by transaction are released. Write a unique difference between a function and a stored procedure. A function … Read more

What is PL/SQL table? Why it is used? Objects of type tables are called PL/SQL tables that are modeled as database table. We can also say that PL/SQL tables are a way to providing arrays. Arrays are like temporary tables in memory that are processed very quickly. PL/SQL tables are used to move bulk data. … Read more

PL/SQL Interview Questions – Set 05 PL/SQL Interview Questions – Set 04 PL/SQL Interview Questions – Set 03 PL/SQL Interview Questions – Set 02 PL/SQL Interview Questions – Set 01