[Solved] Which of the following is the correct syntax to create a simple AFTER INSERT trigger in SQL? — Ans: CREATE TRIGGER trg AFTER INSERT ON employees FOR EACH ROW BEGIN UPDATE stats... | SQL

SQL - Triggers

Which of the following is the correct syntax to create a simple AFTER INSERT trigger in SQL?

ACREATE TRIGGER trg AFTER INSERT employees BEGIN UPDATE stats SET count = count + 1; END;

BCREATE TRIGGER trg AFTER INSERT ON employees FOR EACH ROW BEGIN UPDATE stats SET count = count + 1; END;

CCREATE TRIGGER trg BEFORE UPDATE ON employees FOR EACH ROW UPDATE stats SET count = count + 1;

DCREATE TRIGGER trg ON employees AFTER INSERT BEGIN UPDATE stats SET count = count + 1; END;

Step-by-Step Solution

Solution:

Step 1: Check trigger timing and event
The trigger is AFTER INSERT on the employees table, so syntax must include 'AFTER INSERT ON employees'.
Step 2: Verify trigger body structure
The trigger body must be enclosed in BEGIN ... END; and include FOR EACH ROW for row-level triggers.
Final Answer:
CREATE TRIGGER trg AFTER INSERT ON employees FOR EACH ROW BEGIN UPDATE stats SET count = count + 1; END; -> Option B
Quick Check:
Correct syntax includes timing, event, table, and body [OK]

Quick Trick: Look for 'AFTER INSERT ON table FOR EACH ROW' syntax [OK]

Common Mistakes:

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax to create a simple AFTER INSERT trigger in SQL?