Which SQL statement correctly creates a BEFORE INSERT trigger named trg_update_timestamp on the orders table?

easy📝 Syntax Q3 of 15

SQL - Triggers

Which SQL statement correctly creates a BEFORE INSERT trigger named trg_update_timestamp on the orders table?

ACREATE TRIGGER trg_update_timestamp BEFORE INSERT ON orders FOR EACH ROW SET NEW.updated_at = CURRENT_TIMESTAMP;

BCREATE TRIGGER trg_update_timestamp AFTER INSERT ON orders FOR EACH ROW BEGIN SET NEW.updated_at = CURRENT_TIMESTAMP; END;

CCREATE TRIGGER trg_update_timestamp BEFORE INSERT ON orders FOR EACH ROW BEGIN SET NEW.updated_at = CURRENT_TIMESTAMP; END;

DCREATE TRIGGER trg_update_timestamp ON orders BEFORE INSERT FOR EACH ROW BEGIN SET NEW.updated_at = CURRENT_TIMESTAMP; END;

Step-by-Step Solution

Solution:

Step 1: Identify trigger timing and event
The trigger is BEFORE INSERT on the orders table.
Step 2: Check syntax for trigger body
Standard SQL requires BEGIN ... END block for multiple statements or SET commands.
Step 3: Evaluate options
CREATE TRIGGER trg_update_timestamp BEFORE INSERT ON orders FOR EACH ROW BEGIN SET NEW.updated_at = CURRENT_TIMESTAMP; END; correctly uses BEFORE INSERT, FOR EACH ROW, and a BEGIN ... END block with SET NEW.updated_at = CURRENT_TIMESTAMP;
Final Answer:
Option C -> Option C
Quick Check:
Trigger timing and syntax match standard SQL [OK]

Quick Trick: Use BEGIN...END with SET in BEFORE 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