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:

Brandee
15 days ago
Definitely B. NO ACTION means the database doesn't do anything special when deleting the parent key. It's up to the application to handle the referential integrity.
upvoted 0 times
Mel
2 days ago
I think B is the correct option.
upvoted 0 times
...
...
Precious
16 days ago
Haha, I almost picked D just for the fun of it. Automatically setting all child keys to a specified value? That's a bit extreme for a 'NO ACTION' constraint!
upvoted 0 times
...
Ryan
20 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
22 days ago
I disagree, I believe the answer is D.
upvoted 0 times
...
Yolande
24 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
Annice
3 days ago
I think B is the correct answer.
upvoted 0 times
...
Tarra
5 days ago
I agree, B is the best choice for ON DELETE NO ACTION.
upvoted 0 times
...
Nickole
6 days ago
I think B is the correct answer.
upvoted 0 times
...
...
Gladys
25 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
29 days ago
I think the answer is C.
upvoted 0 times
...

Save Cancel