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)- A82% (36)
- B2% (1)
- C11% (5)
- D5% (2)
Community Discussion
No community discussion yet for this question.