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

SQL - Triggers

Which of the following is the correct syntax to create a DELETE trigger in standard SQL?

ACREATE TRIGGER trg_name BEFORE DELETE ON table_name FOR EACH ROW BEGIN --statements END;

BCREATE DELETE TRIGGER trg_name ON table_name FOR EACH ROW BEGIN --statements END;

CCREATE TRIGGER trg_name ON DELETE table_name BEGIN --statements END;

DCREATE TRIGGER trg_name AFTER DELETE FROM table_name BEGIN --statements END;

Step-by-Step Solution

Solution:

Step 1: Recall standard SQL trigger syntax
Standard syntax uses CREATE TRIGGER name BEFORE/AFTER DELETE ON table FOR EACH ROW.
Step 2: Match options to syntax
CREATE TRIGGER trg_name BEFORE DELETE ON table_name FOR EACH ROW BEGIN --statements END; matches correct syntax; others have wrong keywords or order.
Final Answer:
CREATE TRIGGER trg_name BEFORE DELETE ON table_name FOR EACH ROW BEGIN --statements END; -> Option A
Quick Check:
Standard syntax = CREATE TRIGGER ... BEFORE DELETE ON ... [OK]

Quick Trick: Trigger syntax: CREATE TRIGGER name BEFORE/AFTER DELETE 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 a DELETE trigger in standard SQL?