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 . |