You’re designing a new table that will hold information about medical records. Another table called
documents contains a foreign key that references this table. To make sure information is cleaned
up when a delete operation is performed, you’ve added an ON DELETE CASCADE statement to
the foreign key relationship. What will happen when a row is deleted from the medical records table?

A.
Corresponding rows in the referenced table (documents) will be deleted

B.
All the values that make up the foreign key are set to NULL in the documents table

C.
All the values that comprise the foreign key are set to their default values in the documents table

D.
Rows are deleted from the medical records table but the documents table is unchanged

Explanation:
Don’t forget that ON DELETE statements are included as part of the foreign key relationship.