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