Can a select statement fire a trigger?
What are conditional predicates?
Does a user_objects view have an entry for a trigger?
Explain some predefined exceptions.
Does user triggers have entry for trigger with compilation errors?
Explain 3 basic parts of a trigger.
Show code of a cursor for loop.
What does closing a cursor do?
How many triggers can be applied to a table?
How would you reference column values before and after you have inserted and deleted triggers?
Show the cursor attributes of pl/sql.
Which data dictionary views have the information on the triggers that are available in the database?
What are the events on which a database trigger can be based?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What packages are available to pl/sql developers?