1. List the six DML triggers that Oracle offers.  

2. Explain the differences between row-level and statement-level triggers.  

3. Briefly state how to use each procedure of the DMBS_FGA package.  

4. Identify four drawbacks of the DML audit model, Simple2.  

5. Provide a step-by-step demonstration of a procedure using invoker rights.  

6. LOG in as SYSTEM and list all the triggers in your database.  

7. Demonstrate in detail the differences between statement-level and row-level triggers.

 

Go Back to Course Index

School of Technology
College of Business & Applied Sciences
Eastern Illinois University