PL-SQL Interview Questions

Q. Give the structure of the trigger?
Q. What is an autonomous transaction ?
Q. What are the different cursors available in PL/SQL ?
Q. How do you submit a concurrent program from PL/SQL Procedure?
Q. What is the difference between View and Materialized view?
Q. What is RAISE_APPLICATION_ERROR used for?
Q. What are the three files that are generated when you load data using SQL Loader?
Q. What is dynamic SQL?
Q. What are the types of Exceptions?
Q. What are the differences between Function and Procedure?
Q. What is the difference between TRUNCATE and DELETE?
Q. How do you set the profile option from a PL/SQL procedure?
Q. Name the different database triggers?
Q. What is the SQL statement used to display the text of a procedure stored in database?
Q. How do you retrieve the last N records from a table?
Q. Can you use COMMIT in a trigger?
Q. What is Ref Cursor?
Q. Can triggers be used on views? If so How?
Q. Can you call a sequence in SQL Loader?
Q. How do you declare user defined Exception?
Q. How do you eliminate duplicate rows from a table?
Q. What is a mutating table?
Q. "UPDATE …..; CREATE TABLE E(….); ROLL BACK;" To which save point will the changes be Rolled Back?
Q. What is tkprof and the syntax?
Q. How do you set profile options from PL/SQL procedure?
Q. Have you ever used TABLE datatype and what is it used for?
Q. What do you know about Trace and Tuning?
Q. What is conditional filtering at database level? (Hint: New feature released in 10g)
Q. How do you set the profile option in PL/SQL Procedure?
Q. how to find out duplicate records from the table?
Q. Can two users update the same row at the same time? if so how?
Q. what is External table?
Q. What is global temporary table?
Q. How do you retrieve the last N records from a table?
1
View all
     

Other Categories

Manufacturing
-Order-Management
-Inventory
Tools
-Forms
-Reports
-Workflow
-PL-SQL
--Personalization
General
Financials
-iExpenses
-Payables
-Receivables
-Purchasing