SQL - Triggers
What is the main purpose of a
DELETE trigger in a database?What is the main purpose of a DELETE trigger in a database?
easy📝 Conceptual Q11 of 15
Step-by-Step Solution
Solution:
Step 1: Understand what triggers do
Triggers run automatically in response to certain database events like insert, update, or delete.Step 2: Focus on DELETE triggers
A DELETE trigger specifically runs when rows are deleted, allowing automatic actions during that event.Final Answer:
To automatically run code when rows are deleted from a table -> Option CQuick Check:
DELETE trigger = runs on row deletion [OK]
Quick Trick: DELETE triggers run code automatically on row deletions [OK]
Common Mistakes:
- Confusing DELETE triggers with INSERT triggers
- Thinking DELETE triggers prevent deletion by default
- Assuming DELETE triggers update rows instead
Master "Triggers" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes