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.