Which SQL statement correctly creates a row-level AFTER DELETE trigger named trg_after_delete on a table employees?

easy📝 Conceptual Q2 of 15

SQL - Triggers

Which SQL statement correctly creates a row-level AFTER DELETE trigger named trg_after_delete on a table employees?

ACREATE TRIGGER trg_after_delete AFTER DELETE ON employees FOR EACH ROW BEGIN --actions-- END;

BCREATE TRIGGER trg_after_delete BEFORE DELETE ON employees FOR EACH ROW BEGIN --actions-- END;

CCREATE TRIGGER trg_after_delete AFTER UPDATE ON employees FOR EACH ROW BEGIN --actions-- END;

DCREATE TRIGGER trg_after_delete AFTER DELETE ON employees BEGIN --actions-- END;

Step-by-Step Solution

Solution:

Step 1: Identify correct trigger timing and event
The question asks for AFTER DELETE trigger, so timing is AFTER and event is DELETE.
Step 2: Check syntax for row-level trigger
Syntax requires FOR EACH ROW for row-level triggers and BEGIN...END block for actions.
Final Answer:
CREATE TRIGGER trg_after_delete AFTER DELETE ON employees FOR EACH ROW BEGIN --actions-- END; -> Option A
Quick Check:
Correct syntax = CREATE TRIGGER trg_after_delete AFTER DELETE ON employees FOR EACH ROW BEGIN --actions-- END; [OK]

Quick Trick: AFTER triggers need FOR EACH ROW and event specified [OK]

Common Mistakes:

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes