Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

CIW Exam 1D0-541 Topic 1 Question 66 Discussion

Actual exam question for CIW's 1D0-541 exam
Question #: 66
Topic #: 1
[All 1D0-541 Questions]

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

constraint?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

Ryan
2 days ago
But if the parent key is deleted, wouldn't it make sense for the child keys to be set to a specified value?
upvoted 0 times
...
Verlene
5 days ago
I disagree, I believe the answer is D.
upvoted 0 times
...
Yolande
6 days ago
I was going to choose C, but then I realized that would be the ON DELETE RESTRICT constraint, not NO ACTION. B makes the most sense here.
upvoted 0 times
...
Gladys
7 days ago
I think the correct answer is B. The question clearly states 'NO ACTION', which means no test is made for referential integrity when deleting the parent key.
upvoted 0 times
...
Ryan
11 days ago
I think the answer is C.
upvoted 0 times
...

Save Cancel