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.
|
No comments:
Post a Comment