CIW Exam 1D0-541 Topic 5 Question 47 Discussion

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

Question #: 47
Topic #: 5

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: C

by Charlene at May 07, 2022, 05:56 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!