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

SQL - Triggers

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

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

BCREATE TRIGGER trg AFTER INSERT ON table_name BEGIN ... END;

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

DCREATE TRIGGER trg BEFORE INSERT ON table_name FOR EACH ROW BEGIN ... END;

Step-by-Step Solution

Solution:

Step 1: Identify correct trigger timing and event
The question asks for a BEFORE INSERT trigger, so timing is BEFORE and event is INSERT.
Step 2: Match syntax
CREATE TRIGGER trg BEFORE INSERT ON table_name FOR EACH ROW BEGIN ... END; matches CREATE TRIGGER trg BEFORE INSERT ON table_name FOR EACH ROW BEGIN ... END;. Other options have wrong timing or event.
Final Answer:
CREATE TRIGGER trg BEFORE INSERT ON table_name FOR EACH ROW BEGIN ... END; -> Option D
Quick Check:
BEFORE INSERT syntax = CREATE TRIGGER trg BEFORE INSERT ON table_name FOR EACH ROW BEGIN ... END; [OK]

Quick Trick: BEFORE triggers use 'BEFORE event ON table' 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 BEFORE INSERT trigger in SQL?