Which trigger option will force the trigger to fire before the test_trg trigger.
A) BEFORE test_trg
B) PRECEDES test_trg
C) PRIOR test_trg
D) no option is available to control the firing order

Question

Quizplus · Accepted Answer

The PRECEDES trigger option forces the trigger to fire before test_trg. This option allows for explicit control over the firing order of triggers. Option A (BEFORE) and option C (PRIOR) both have the same functionality as PRECEDES in terms of firing the trigger before test_trg, but they do not provide explicit control over the firing order of other triggers. Option D is incorrect as there is an option available to control the firing order.

Which Trigger Option Will Force the Trigger to Fire Before