Pl sql Interview Questions

Pl sql Interview Questions
Where is the WHERE CURRENT OF clause required in cursors?
Where do we store the features of package, procedure and functions?
Discuss the cursor attributes available in pl/sql.
Explain forward declaration used in functions.
If we call a column updating procedure in the database trigger of the same table?
Explain the two virutal tables which are used while execution of database.
Explain the difference between Function and Procedure.
What do you understand by a Raise_application_error?
Explain the various types of database triggers possible on a table.
What do you mean by ref cursor?
Describe the method of calling functions and procedures in a PL/SQL block.
What do you understand by Trigger, function, cursor in pl-sql?
Are the Rollback or Commit Transaction Control Statements useful in Database Trigger?
Explain the various uses and limitations of cursor.
What are the constituents of a package?
Describe the basic structure of PL/SQL.
Method of dubugging the procedure.
Method for insertion of records in a table. How do we make a table? Provide suitable examples.
Describe a cursor for loop.
Where in memory are the Pre_defined_exceptions stored?
What do you understand by Pragma EXCEPTION_INIT?
Describe the various types of cursors.
Describe the difference between application procedure and stored procedure.
What do you understand by PL/SQL?
Explain the various restrictions on cursor variables.
Explain the use of procedure to make a table.
What do you understand by database trigger? What are its uses?
Describe the difference between application function and stored function.
How can we use commit, savepoint and rollback in database triggers?
How is a cursor different in a procedure and package specification?
What are the advantages of using PL/SQL?
What do you know about rowid and rownum?
Which pl/sql statements are required in cursor processing?
What do you understand by a stored procedure?
Define the %TYPE and % ROWTYPE. What is the benefit of these datatypes?
Explain the meaning of “Overloading of Procedures”.
Why do we use OUT Parameter in pl/sql while we have the return statement?
What are the results of using commit statement?
What do you mean by an Exception?
Various advantages of using stored procedures.
Explain the structure of a procedure.
Describe a function’s structure.
Why do we need a cursor?
Explain the various types of exceptions.
What does the function SQLCODE return?
What does the function SQLERRM return?
Explain the difference between implicit and explicit cursors.
Can you queries be run simultaneously in a distributed database system?
List the various components found in a PL/SQL Block.
Describe the points of difference between % ROWTYPE and TYPE RECORD.
Discuss the various components of a procedure.
When should we not use cursors?
Give an example of a PL SQL Table.
Describe the modes of parameters which a procedure can have?
How can we disable multiple triggers of a table at a time?
Which datatypes can be found in PL/SQL?

No comments: