SQL - Table Constraints
Which of the following is the correct syntax to define a foreign key with
ON UPDATE RESTRICT in SQL?Which of the following is the correct syntax to define a foreign key with ON UPDATE RESTRICT in SQL?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Identify ON UPDATE RESTRICT syntax
The correct syntax uses ON UPDATE RESTRICT after the REFERENCES clause.Step 2: Check options for correct placement
FOREIGN KEY (child_id) REFERENCES parent(id) ON UPDATE RESTRICT correctly places ON UPDATE RESTRICT after the foreign key reference.Final Answer:
FOREIGN KEY (child_id) REFERENCES parent(id) ON UPDATE RESTRICT -> Option DQuick Check:
ON UPDATE RESTRICT syntax = FOREIGN KEY (child_id) REFERENCES parent(id) ON UPDATE RESTRICT [OK]
Quick Trick: ON UPDATE RESTRICT follows REFERENCES clause [OK]
Common Mistakes:
MISTAKES- Confusing ON UPDATE with ON DELETE
- Placing ON UPDATE before REFERENCES
- Using CASCADE instead of RESTRICT
Master "Table Constraints" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes