SQL - Triggers
Consider a DELETE trigger that prevents deletion if the employee's salary is above 100000. What will happen if you try to delete such an employee?
Consider a DELETE trigger that prevents deletion if the employee's salary is above 100000. What will happen if you try to delete such an employee?
medium📝 query result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Understand conditional DELETE triggers
Triggers can check conditions and raise errors to block deletes.Step 2: Effect of salary condition
If salary > 100000, trigger raises error and stops deletion.Final Answer:
The deletion is blocked and an error is raised -> Option BQuick Check:
Conditional DELETE trigger can block deletion [OK]
Quick Trick: Use triggers to block deletes by raising errors [OK]
Common Mistakes:
- Assuming trigger cannot block deletes
- Thinking deletion proceeds despite condition
- Confusing logging with blocking
Master "Triggers" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes