Which of the following is the correct way to create an INSTEAD OF trigger on a view named sales_view that fires on DELETE events?

easy📝 Syntax Q3 of 15

PostgreSQL - Triggers in PostgreSQL

Which of the following is the correct way to create an INSTEAD OF trigger on a view named sales_view that fires on DELETE events?

ACREATE TRIGGER trg_delete INSTEAD OF DELETE ON sales_view FOR EACH STATEMENT EXECUTE FUNCTION trg_sales_delete();

BCREATE TRIGGER trg_delete AFTER DELETE ON sales_view FOR EACH STATEMENT EXECUTE FUNCTION trg_sales_delete();

CCREATE TRIGGER trg_delete BEFORE DELETE ON sales_view FOR EACH ROW EXECUTE FUNCTION trg_sales_delete();

DCREATE TRIGGER trg_delete INSTEAD OF DELETE ON sales_view FOR EACH ROW EXECUTE FUNCTION trg_sales_delete();

Step-by-Step Solution

Solution:

Step 1: Identify trigger timing and event
INSTEAD OF triggers are defined with the keyword INSTEAD OF and specify the event (INSERT, UPDATE, DELETE).
Step 2: Determine the granularity
INSTEAD OF triggers on views must be FOR EACH ROW to handle individual row operations.
Step 3: Verify syntax
The correct syntax is: CREATE TRIGGER name INSTEAD OF event ON view FOR EACH ROW EXECUTE FUNCTION function_name();
Final Answer:
CREATE TRIGGER trg_delete INSTEAD OF DELETE ON sales_view FOR EACH ROW EXECUTE FUNCTION trg_sales_delete(); -> Option D
Quick Check:
INSTEAD OF triggers require FOR EACH ROW on views [OK]

Quick Trick: INSTEAD OF triggers on views use FOR EACH ROW [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free