Bird
0
0

A foreign key constraint with ON DELETE CASCADE is not deleting child rows as expected. What could be the problem?

medium📝 Debug Q7 of 15
SQL - Table Constraints
A foreign key constraint with ON DELETE CASCADE is not deleting child rows as expected. What could be the problem?
AThe foreign key constraint was created without ON DELETE CASCADE.
BThe parent table has no rows.
CThe child table has no foreign key column.
DThe database engine does not support foreign keys.
Step-by-Step Solution
Solution:

  1. Step 1: Check foreign key constraint definition

    If ON DELETE CASCADE was not specified, child rows won't be deleted automatically.

  2. Step 2: Verify other options

    Parent table having no rows or child table missing foreign key column would cause other errors, not this behavior.

  3. Final Answer:

    The foreign key constraint was created without ON DELETE CASCADE. -> Option A

  4. Quick Check:

    ON DELETE CASCADE must be defined to delete child rows [OK]
Quick Trick: ON DELETE CASCADE must be explicitly set [OK]
Common Mistakes:
MISTAKES
  • Assuming CASCADE is default behavior
  • Ignoring constraint definition
  • Blaming database engine without checking

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Aggregate Functions - MIN and MAX functions - Quiz 10hard Aggregate Functions - Aggregate with NULL handling - Quiz 11easy GROUP BY and HAVING - HAVING clause for filtering groups - Quiz 13medium INNER JOIN - INNER JOIN with table aliases - Quiz 13medium INNER JOIN - INNER JOIN syntax - Quiz 14medium INNER JOIN - INNER JOIN with ON condition - Quiz 14medium INNER JOIN - INNER JOIN syntax - Quiz 15hard LEFT and RIGHT JOIN - RIGHT JOIN execution behavior - Quiz 5medium Set Operations - Why set operations are needed - Quiz 4medium Table Relationships - Why understanding relationships matters - Quiz 2easy