If two AFTER DELETE triggers exist on table products, and the second trigger is defined with FOLLOWS first_trigger, what is the execution order?

medium📝 query result Q5 of 15

PostgreSQL - Triggers in PostgreSQL

If two AFTER DELETE triggers exist on table products, and the second trigger is defined with FOLLOWS first_trigger, what is the execution order?

ABoth triggers run simultaneously.

Bsecond_trigger runs before first_trigger.

Cfirst_trigger runs before second_trigger.

DExecution order is undefined.

Step-by-Step Solution

Solution:

Step 1: Understand FOLLOWS clause meaning
FOLLOWS means the trigger runs after the named trigger.
Step 2: Apply to given triggers
second_trigger FOLLOWS first_trigger means first_trigger runs first, then second_trigger.
Final Answer:
first_trigger runs before second_trigger. -> Option C
Quick Check:
FOLLOWS sets execution order = first_trigger runs before second_trigger. [OK]

Quick Trick: FOLLOWS means run after the named trigger [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free