SQL - Triggers
A trigger is not firing after an UPDATE on table Customers. Which fix is most likely needed?
A trigger is not firing after an UPDATE on table Customers. Which fix is most likely needed?
medium📝 Debug Q7 of 15
Step-by-Step Solution
Solution:
Step 1: Understand trigger firing conditions
Row-level triggers require FOR EACH ROW to run for each updated row.Step 2: Identify missing element causing no firing
Without FOR EACH ROW, the trigger may not execute as expected on row updates.Final Answer:
Add FOR EACH ROW clause to the trigger -> Option BQuick Check:
FOR EACH ROW enables trigger firing per row [OK]
Quick Trick: FOR EACH ROW ensures trigger runs on every row update [OK]
Common Mistakes:
- Changing timing unnecessarily
- Renaming triggers incorrectly
- Removing valid WHEN conditions
Master "Triggers" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes