PL/SQL Interview Questions and Answers

PL/SQL Interview Questions and Answers

PL-SQL stands for Procedural Language Extensions to SQL (Structured Query Language).It is an extension of SQL language that is used to Oracle. It is designed specifically to embrace SQL statements within its syntax.PL/SQL program units are compiled by the Oracle Database server and stored inside the database.PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedure and functions, types and variables of those types, integers and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections)

What is PL/SQL?

What are the different types of expressions?

What is a exception?

Can you define cursor?

What are the schema objects that are created using PL/SQL?

What is cluster?

What is Hash cluster?

What is the difference between % ROWTYPE and TYPE RECORD

Can you explain database trigger?

Can you explain two virtual tables available at the time of database trigger execution?

Can you explain Raise_application_error?

Can you define functions and procedures?

Can you explain process of PL/SQL compiled?

What is an Exception? What are types of Exception?

What is the difference between DECODE and CASE?

What is the difference between syntax and runtime errors?

What is the difference between SQLCODE and SQLERRM?

What are the three basic sections of a PL/SQL block?

Can you explain mutating table error?

Can you explain declare statement?

What does closing a cursor do?

What are the predefined exceptions?

What are the rules to be applied to NULLs whilst doing comparisons?

Can you explain PL/SQL Placeholders?

What will happen after commit statement?

Does SQL*Plus also have a PL/SQL Engine?

What is difference between a PROCEDURE and FUNCTION?

What is the difference between Anonymous blocks and sub-programs?

Can you explain module overloading?

How many triggers can be applied to a table?

What does the argument ‘OR REPLACE’ do?

What are the characteristics of PL/SQL?

What does fetching a cursor do?

Can you define Intersect in PL/SQL?

Can you define sequences in PL/SQL?

How can you rebuild an index?

Can you explain Consistency?

Can you explain autonomous transaction?

Can you explain materialized views ?

Can you define Commit, Rollback and Save point?

Which packages are available to PL/SQL developers?

What is the error ORA-03113? What are the different types of errors?

Why ORA-03113 error will come?

Can you explain error ORA-01555?

Can you explain Pragma EXECPTION_INIT ?

What is Raise_application_error?

Can you explain character functions?

What are the cursors attributes of PL/SQL?

Can you explain PL/SQL Records?

What is TTITLE and BTITLE?

Can you explain the SYSDATE and USER keywords?

How does ROWID help in running a query faster?

What are database links used for?

What is use to look at the size of a data file?

Which command is used to delete a package?

What types of tables involved in producing a star schema and the type of data they hold.

What type of index should you use on a fact table?

Give two examples of referential integrity constraints?

How might you determine to use PL/SQL Native Compilation to speed your code?

Which command is use to create a backup control file?

Can you explain the uses of Control File

Which command is use to encrypt a PL/SQL application?