Oracle PL[s]SQL by Example

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.

  1. _____ True

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

  1. _____ True

  2. _____ False

3)

Which of the following is an SQL statement restriction?

  1. _____ No SQL statement may be issued against any table in the body of a trigger.

  2. _____ No SQL statement may be issued against the mutating table in the body of a trigger.

  3. _____ 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?

  1. _____ A table having a SELECT statement issued against it

  2. _____ A table having a trigger defined on it

  3. _____ A table being modified by a DML statement

5)

Which of the following is a constraining table?

  1. _____ A table having a SELECT statement issued against it

  2. _____ A table having a trigger defined on it

  3. _____ A table needing to be read from for a referential integrity constraint

Answers appear in Appendix A, Section 17.3 .

Related

Категории