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