[Solved] You wrote this AFTER UPDATE trigger:CREATE TRIGGER trg AFTER UPDATE ON employeesBEGIN UPDATE employees SET salary = salary * 1.1 WHERE id = NEW.... | SQL

SQL - Triggers

You wrote this AFTER UPDATE trigger:

CREATE TRIGGER trg AFTER UPDATE ON employees
BEGIN
  UPDATE employees SET salary = salary * 1.1 WHERE id = NEW.id;
END;

What problem will occur when you update an employee's salary?

ASalary will not change

BTrigger will not run at all

CSyntax error prevents trigger creation

DInfinite loop causing stack overflow

Step-by-Step Solution

Solution:

Step 1: Analyze trigger logic
The trigger updates the same table it is triggered on, causing the trigger to fire again.
Step 2: Identify the effect of recursive updates
This causes an infinite loop of updates, eventually causing stack overflow or error.
Final Answer:
Infinite loop causing stack overflow -> Option D
Quick Check:
Trigger updating same table without stop = infinite loop [OK]

Quick Trick: Avoid triggers updating same table without condition to stop recursion [OK]

Common Mistakes:

Master "Triggers" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

You wrote this AFTER UPDATE trigger: