Sams Teach Yourself SQL in 21 Days, Fourth Edition

Day 20

Quiz

1:	What are the three basic components of a trigger?
A1:	The execution statement, the trigger restrictions, and the trigger action.
2:	What are the three events that can cause a trigger to fire?
A2:	The INSERT, UPDATE, and DELETE events.
3:	What is the advantage of implementing role security?
A3:	Many privileges can be granted to a role. Then the role can be granted to many users (instead of many privileges). Privileges are granted and revoked much easier, and you can break your database users into groups, whereby each group is allowed to perform certain actions.
4:	Name four uses for a trigger.
A4:	Data manipulation, referential integrity enforcement, database auditing and monitoring, and business rules enforcement.
5:	For what does the ...