Lab 17.2 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

1)	How many times does a row trigger fire if a DML (INSERT, UPDATE, or DELETE) operation is issued against a table? _____ As many times as there are rows affected by the DML operation _____ Once per DML operation
2)	How many times does a statement trigger fire if a DML (INSERT, UPDATE, or DELETE) operation is issued against a table? _____ As many times as there are rows affected by the DML operation _____ Once per DML operation
3)	What does the statement FOR EACH ROW mean? _____ A trigger is a statement trigger. _____ A trigger is a row trigger.
4)	INSTEAD OF triggers are defined on which of the following? _____ Table _____ View _____ None of the above
5)	INSTEAD OF triggers must always be which of the following? _____ Statement trigger _____ Row trigger

Answers appear in Appendix A, Section 17.2 .