Lab 17.1 Self-Review Questions

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

1)	A trigger can fire for which of the following? _____ Before a triggering event _____ After a triggering event _____ Before or after a triggering event
2)	How is a trigger executed? _____ Explicitly when a triggering event occurs _____ Implicitly when a triggering event occurs
3)	In order for a trigger to fire, the WHEN condition must evaluate to which of the following? _____ True _____ False
4)	A BEFORE INSERT trigger fires for which of the following? _____ Before an UPDATE is issued against the triggering table _____ After an INSERT is issued against the triggering table _____ Before an INSERT is issued against the triggering table
5)	When a SELECT statement is issued against the triggering table, which of the following triggers fire? _____ BEFORE trigger _____ AFTER trigger _____ BEFORE trigger and AFTER trigger _____ Triggers are not fired at all.

Answers appear in Appendix A, Section 17.1 .