Oracle PL[s]SQL by Example

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

1)

A trigger can fire for which of the following?

  1. _____ Before a triggering event

  2. _____ After a triggering event

  3. _____ Before or after a triggering event

2)

How is a trigger executed?

  1. _____ Explicitly when a triggering event occurs

  2. _____ Implicitly when a triggering event occurs

3)

In order for a trigger to fire, the WHEN condition must evaluate to which of the following?

  1. _____ True

  2. _____ False

4)

A BEFORE INSERT trigger fires for which of the following?

  1. _____ Before an UPDATE is issued against the triggering table

  2. _____ After an INSERT is issued against the triggering table

  3. _____ Before an INSERT is issued against the triggering table

5)

When a SELECT statement is issued against the triggering table, which of the following triggers fire?

  1. _____ BEFORE trigger

  2. _____ AFTER trigger

  3. _____ BEFORE trigger and AFTER trigger

  4. _____ Triggers are not fired at all.

Answers appear in Appendix A, Section 17.1 .

Related

Категории