CIW
1D0-541 · Question #53
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…
The correct answer is C. A deletion anomaly would occur. See the full explanation below for the reasoning.
Question
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?
Options
- 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.
How the community answered
(40 responses)- A3% (1)
- B13% (5)
- C80% (32)
- D5% (2)
Community Discussion
No community discussion yet for this question.