Which of the following is the correct way to create a row-level AFTER UPDATE trigger on a table named employees?

easy📝 Syntax Q3 of 15

SQL - Triggers

Which of the following is the correct way to create a row-level AFTER UPDATE trigger on a table named employees?

ACREATE TRIGGER trg BEFORE UPDATE ON employees FOR EACH STATEMENT BEGIN -- trigger body END;

BCREATE TRIGGER trg AFTER UPDATE ON employees FOR EACH ROW BEGIN -- trigger body END;

CCREATE TRIGGER trg AFTER DELETE ON employees FOR EACH ROW BEGIN -- trigger body END;

DCREATE TRIGGER trg AFTER UPDATE ON employees BEGIN -- trigger body END;

Step-by-Step Solution

Solution:

Step 1: Identify trigger timing and event
The question asks for AFTER UPDATE trigger.
Step 2: Identify row-level syntax
Row-level triggers use FOR EACH ROW clause.
Step 3: Match syntax
CREATE TRIGGER trg AFTER UPDATE ON employees FOR EACH ROW BEGIN -- trigger body END; correctly uses AFTER UPDATE ON employees FOR EACH ROW.
Final Answer:
CREATE TRIGGER trg AFTER UPDATE ON employees FOR EACH ROW BEGIN -- trigger body END; -> Option B
Quick Check:
AFTER UPDATE + FOR EACH ROW required [OK]

Quick Trick: Row-level AFTER triggers need FOR EACH ROW [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