Which of the following statements is correct?
A) If multiple triggers exist on a table, the order in which the triggers will be fired can be set.
B) A BEFORE statement level trigger will fire before a BEFORE row level trigger.
C) If you have two statement level triggers, the order in which they are fired is dependent on the order in which they were written.
D) Only one trigger can be constructed per table.

Question

Quizplus · Accepted Answer

In Oracle, triggers can be classified as either statement level or row level, and as either before or after the triggering statement. If multiple triggers exist on a table, the order of execution depends on the type and timing of the triggers. BEFORE row-level triggers will fire before BEFORE statement-level triggers, and AFTER statement-level triggers will fire before AFTER row-level triggers. However, there is no way to set the firing order of multiple triggers of the same type and timing. Additionally, multiple triggers can be constructed per table.

Which of the Following Statements Is Correct