Which of the following is the correct syntax to create an AFTER DELETE trigger on a table named 'employees'?

easy📝 Syntax Q3 of 15

PostgreSQL - Triggers in PostgreSQL

ACREATE TRIGGER trg_after_delete AFTER DELETE ON employees FOR EACH ROW EXECUTE FUNCTION log_delete();

BCREATE TRIGGER trg_after_delete BEFORE DELETE ON employees FOR EACH ROW EXECUTE FUNCTION log_delete();

CCREATE TRIGGER trg_after_delete AFTER DELETE ON employees FOR EACH STATEMENT EXECUTE FUNCTION log_delete();

DCREATE TRIGGER trg_after_delete AFTER UPDATE ON employees FOR EACH ROW EXECUTE FUNCTION log_delete();"

Step-by-Step Solution

Solution:

Step 1: Identify correct timing and event
The trigger must be AFTER DELETE on the 'employees' table.
Step 2: Confirm syntax for row-level trigger
FOR EACH ROW is correct for row-level triggers; the function name is log_delete().
Final Answer:
CREATE TRIGGER trg_after_delete AFTER DELETE ON employees FOR EACH ROW EXECUTE FUNCTION log_delete(); -> Option A
Quick Check:
Correct AFTER DELETE syntax = CREATE TRIGGER trg_after_delete AFTER DELETE ON employees FOR EACH ROW EXECUTE FUNCTION log_delete(); [OK]

Quick Trick: AFTER triggers use EXECUTE FUNCTION with correct event and timing [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