CIW Exam 1D0-541 Topic 4 Question 93 Discussion

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

Question #: 93
Topic #: 4

[All 1D0-541 Questions]

The exhibit shows a table called Activity Relation that relates a unique student identification

number with a sports activity and a fee for participating in that activity. A student can participate

in only one activity. The key for the relation is Student_ID. What consequence would occur if the

tuple for Student_ID 1001 were removed?

AAn update anomaly would occur.

BAn insertion anomaly would occur.

CA deletion anomaly would occur.

DBoth an insertion anomaly and a deletion anomaly would occur.

Show Suggested Answer

Suggested Answer: D

by Paola at Jul 18, 2024, 09:42 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 days ago

I agree with Alexia, removing Student_ID 1001 would cause a deletion anomaly.

upvoted 0 times

...

4 days ago

I think if Student_ID 1001 is removed, a deletion anomaly would occur.

upvoted 0 times

...