Lab 17.3 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

1)	You are allowed to issue any SQL statement in the body of a trigger. _____ True _____ False
2)	It is always permissible to issue a SELECT statement in the body of a trigger. However, it is not always permissible to issue an INSERT, UPDATE, or DELETE statement. _____ True _____ False
3)	Which of the following is an SQL statement restriction? _____ No SQL statement may be issued against any table in the body of a trigger. _____ No SQL statement may be issued against the mutating table in the body of a trigger. _____ A SQL statement can be issued only against the mutating table in the body of a trigger.
4)	Which of the following is a mutating table? _____ A table having a SELECT statement issued against it _____ A table having a trigger defined on it _____ A table being modified by a DML statement
5)	Which of the following is a constraining table? _____ A table having a SELECT statement issued against it _____ A table having a trigger defined on it _____ A table needing to be read from for a referential integrity constraint

Answers appear in Appendix A, Section 17.3 .