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?

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

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

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

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

Show Suggested Answer

Suggested Answer: A

by Keneth at Mar 02, 2023, 07:30 AM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Brandee

5 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

...

Precious

7 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

10 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

13 days ago

I disagree, I believe the answer is D.

upvoted 0 times

...

Yolande

15 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

16 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

19 days ago

I think the answer is C.

upvoted 0 times

...