Differentiate between function and procedure in oracle.
Give the constructs of a package, function or a procedure.
Which are the five query types available in oracle?
Explain parameter file in oracle.
Is a rollback possible to any savepoint?
Give the various rollback segment states.
Explain cascading triggers.
What is a mutating table and a constraining table?
Why triggers are used?
Explain cursor types?
What are pl/sql cursors?
Explain the difference between triggers and constraints?
Enlist the data types that can be used in pl/sql?
What is the difference between function, procedure and package in pl/sql?
What is the difference between execution of triggers and stored procedures?