Review

3 4

The following questions are intended to reinforce key information presented in this chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. You can find answers to the questions in Appendix A, "Questions and Answers."

1. You have applied constraints, an INSTEAD OF trigger, and three AFTER triggers to a table. A colleague tells you that there is no way to control trigger order for the table. Is he correct? Why or why not?
2. You need to make sure that when a primary key is updated in one table, all foreign key references to it are also updated. How should you accomplish this task?
3. Name four instances when triggers are appropriate.
4. When a trigger fires, how does it track the changes that have been made to the modified table?
5. Name a table deletion event that does not fire a DELETE trigger.
6. Name a system stored procedure and a function used to view the properties of a trigger.
7. Using Transact-SQL language, what are two methods to stop a trigger from running?
8. Write a (COLUMNS_UPDATED()) clause that detects whether columns 10 and 11 are updated.
9. Name three common database tasks accomplished with triggers.
10. What command can you use to prevent a trigger from displaying row count information to a calling application?
11. What type of event creates both an Inserted and Deleted logical table?
12. Is it possible to instruct a trigger to display result sets and print messages?