Which of the following best describes the ON DELETE CASCADE referential integrity constraint?
A.
If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.
B.
If any child key references a parent key, the record containing the parent key cannot be deleted.
C.
If a parent key isdeleted, all child keys are automatically set to a specified value.
D.
If a parent key is deleted, no test is made for referential integrity.