Chapter 8 Review Questions from book "DATABASE SECURITY AND AUDITING: Protecting Data Integrity and Accessibility" by Hassan A. Afyouni

1. List all DML triggers available in Microsoft SQL Server. 2. Explain the difference between row-level and statement-level triggers. 3. List five statements that are not allowed in Microsoft SQL Server triggers. 4. What are the restrictions of the INSTEAD OF clause in the Microsoft SQL Server triggers? 5. Identify four drawbacks of the DML audit model, Simple 2. 6. Give an example (not a full implementation of how to use a trigger condition in Microsoft SQL Server trigger 7. Provide a step-by-step demonstration of a procedure using invoker rights. 8. What is the use of logical tables in Microsoft SQL Server triggers? 9. Log in as SYSTEM and list all the triggers in your database. 10. Demonstrate in detail the difference between statement-level and row-level triggers