CIW Exam 1D0-541 Topic 1 Question 104 Discussion

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

Question #: 104
Topic #: 1

[All 1D0-541 Questions]

Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers.

Which situation would occur if new supplier information were entered in the relation before any

information about specific parts?

AAn update anomaly and an insertion anomaly would occur.

BAn insertion anomaly would occur.

CA deletion anomaly would occur.

DA deletion anomaly and an update anomaly would occur.

Show Suggested Answer

Suggested Answer: C

by Cassandra at Dec 04, 2024, 04:16 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

20 hours ago

I'm pretty sure an update anomaly will happen too. Gotta love those database quirks, am I right?

upvoted 0 times

...

4 days ago

If we add supplier info before parts, we'll have an insertion anomaly for sure. That's a big no-no in database design!

upvoted 0 times

...

22 days ago

I believe option B is the correct answer then, as it mentions an insertion anomaly.

upvoted 0 times

...

23 days ago

I agree with you, William. It could lead to data inconsistency and errors.

upvoted 0 times

...

24 days ago

I think if new supplier information is entered before parts, there could be an insertion anomaly.

upvoted 0 times

...