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

2 months 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

Ruby

5 days ago

I think B is the correct option.

upvoted 0 times

...

Cherelle

16 days ago

Exactly, it's important for the application to manage that.

upvoted 0 times

...

Shizue

1 months ago

So, the application has to handle the referential integrity.

upvoted 0 times

...

Desiree

1 months ago

I agree, NO ACTION means no special action is taken.

upvoted 0 times

...

Mel

1 months ago

I think B is the correct option.

upvoted 0 times

...

Precious

2 months 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

2 months 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

2 months ago

I disagree, I believe the answer is D.

upvoted 0 times

...

Yolande

2 months 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

Justa

27 days ago

Yes, B is the right choice for this referential integrity constraint.

upvoted 0 times

...

Dortha

1 months ago

I was also considering C at first, but B is the correct option.

upvoted 0 times

...

James

1 months ago

Yes, B is the correct answer for ON DELETE NO ACTION.

upvoted 0 times

...

Annice

1 months ago

I think B is the correct answer.

upvoted 0 times

...

Tarra

1 months ago

I agree, B is the best choice for ON DELETE NO ACTION.

upvoted 0 times

...

Nickole

1 months ago

I think B is the correct answer.

upvoted 0 times

...

Gladys

2 months 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

2 months ago

I think the answer is C.

upvoted 0 times

...