nerdexam
CIW

1D0-441 · Question #38

Which of the following best describes the ON UPDATE CASCADE referential integrity constraint?

The correct answer is A. If a parent key is updated, any child keys that reference the parent key are automatically updated. See the full explanation below for the reasoning.

Question

Which of the following best describes the ON UPDATE CASCADE referential integrity constraint?

Options

  • AIf a parent key is updated, any child keys that reference the parent key are automatically updated.
  • BIf a parent key is updated, all child keys are automatically set to a specified value.
  • CIf a parent key is updated, no test is made for referential integrity.
  • DIf a parent key is updated, any child keys that reference the parent key cannot be updated.

How the community answered

(44 responses)
  • A
    82% (36)
  • B
    2% (1)
  • C
    11% (5)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice