Which referential action automatically deletes related child records when a referenced parent record is deleted?
Options
-
A.
ON DELETE CASCADE
-
B.
ON UPDATE SET DEFAULT
-
C.
ON INSERT CASCADE
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
ON DELETE CASCADE
Detailed Explanation
- ON DELETE CASCADE: Automatically deletes matching child records when the referenced parent record is deleted.
- It is defined as part of a foreign key constraint.
- It helps maintain referential integrity across related tables.
OOps! You are currently offline.