Which of the below is a reference option for deleting rows from a table?
Answer options
A
ON DELETE CASCADE
B
ON DELETE RESTRICT
C
ON DELETE SET NULL
D
ON DELETE NO ACTION
Correct answer: ON DELETE CASCADE
Explanation
Quick AnswerThe correct answer is ON DELETE CASCADE because it directly addresses the core logic of Database Management.
ON DELETE CASCADE automatically deletes child rows when the parent row is deleted.