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

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

Contribute your Thoughts:

Submit Cancel

Remedios

5 days ago

Removing the tuple for Student_ID 1001 would result in a deletion anomaly. The sports activity and fee information for that student would be lost, which is not desirable.

upvoted 0 times

...

Marleen

6 days ago

I believe the correct answer is C) A deletion anomaly would occur because removing a tuple can result in losing related data.

upvoted 0 times

...

Ressie

10 days ago

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

upvoted 0 times

...

Alexia

13 days ago

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

upvoted 0 times

...