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 . |
لطفا منتظر باشید ...
