CIW Exam 1D0-541 Topic 3 Question 95 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 95
Topic #: 3

[All 1D0-541 Questions]

Which of the following best describes the ON DELETE CASCADE referential integrity

constraint?

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

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

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

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

Show Suggested Answer

Suggested Answer: A

by Larue at Aug 28, 2024, 08:55 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Eveline

7 days ago

B) Oh, that's the one where you can't delete the parent key if there are any child keys. Sounds like a great way to keep your data integrity intact.

upvoted 0 times

...

Lemuel

14 days ago

Actually, the correct answer is A. When a parent key is deleted, all child keys referenced by the parent key are automatically deleted.

upvoted 0 times

...

29 days ago

A) For sure, that's the right answer. I've used ON DELETE CASCADE many times to clean up my database.

upvoted 0 times

Vinnie

1 days ago

A) It's a great way to automatically delete related records when a parent record is deleted.

upvoted 0 times

...

Margart

6 days ago

B) I always make sure to use ON DELETE CASCADE to avoid orphaned records in my database.

upvoted 0 times

...

Robt

23 days ago

A) I agree, ON DELETE CASCADE is really useful for maintaining referential integrity.

upvoted 0 times

...

Karan

1 months ago

I agree with Kanisha, because ON DELETE CASCADE means child keys are automatically deleted.

upvoted 0 times

...

Kanisha

1 months ago

I think the answer is A.

upvoted 0 times

...