CIW Exam Questions

Which of the following best describes the ON DELETE NO ACTION referential integrity constraint?

Which of the following best describes the ON DELETE NO ACTION referential integrity constraint?

A.
If a parent key is deleted, any child keys referenced by the parent key are automatically
deleted.

B.
If a parent key is deleted, no test is made for referential integrity.

C.
If any child key references a parent key, the record containing the parent key cannot be
deleted.

D.
If a parent key is deleted, all child keys are automatically set to a specified value.