Which of the following is the correct syntax to create a trigger that fires after an INSERT on a table named employees?

easy📝 Syntax Q12 of 15

SQL - Triggers

Which of the following is the correct syntax to create a trigger that fires after an INSERT on a table named employees?

ACREATE TRIGGER trg AFTER INSERT ON employees FOR EACH ROW BEGIN ... END;

BCREATE TRIGGER trg BEFORE UPDATE ON employees FOR EACH ROW BEGIN ... END;

CCREATE TRIGGER trg AFTER DELETE ON employees FOR EACH ROW BEGIN ... END;

DCREATE TRIGGER trg ON employees AFTER INSERT BEGIN ... END;

Step-by-Step Solution

Solution:

Step 1: Identify correct trigger timing and event
The question asks for a trigger after INSERT, so it must say AFTER INSERT.
Step 2: Check syntax correctness
CREATE TRIGGER trg AFTER INSERT ON employees FOR EACH ROW BEGIN ... END; uses correct syntax: CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW BEGIN ... END;
Final Answer:
CREATE TRIGGER trg AFTER INSERT ON employees FOR EACH ROW BEGIN ... END; -> Option A
Quick Check:
Trigger syntax = CREATE TRIGGER ... AFTER INSERT ON ... [OK]

Quick Trick: Use AFTER INSERT ON table FOR EACH ROW for insert triggers [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