[Solved] Which of the following is the correct syntax to create an INSERT trigger in SQL? — Ans: CREATE TRIGGER trg AFTER INSERT ON table_name FOR EACH ROW BEGIN ... END; | SQL

SQL - Triggers

Which of the following is the correct syntax to create an INSERT trigger in SQL?

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

BCREATE TRIGGER trg BEFORE DELETE ON table_name FOR EACH ROW BEGIN ... END;

CCREATE TRIGGER trg AFTER UPDATE ON table_name FOR EACH ROW BEGIN ... END;

DCREATE TRIGGER trg ON table_name INSERT BEGIN ... END;

Step-by-Step Solution

Solution:

Step 1: Identify correct event and timing
For an INSERT trigger, the event is INSERT and timing can be BEFORE or AFTER. CREATE TRIGGER trg AFTER INSERT ON table_name FOR EACH ROW BEGIN ... END; uses AFTER INSERT which is valid.
Step 2: Check syntax structure
CREATE TRIGGER trg AFTER INSERT ON table_name 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 table_name FOR EACH ROW BEGIN ... END; -> Option A
Quick Check:
Correct INSERT trigger syntax = CREATE TRIGGER trg AFTER INSERT ON table_name FOR EACH ROW BEGIN ... END; [OK]

Quick Trick: INSERT triggers use AFTER or BEFORE INSERT ON table [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 an INSERT trigger in SQL?