PrepAway - Latest Free Exam Questions & Answers

What consequence would occur if the tuple for Student_ID 1001 were removed?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
An update anomaly would occur.

B.
An insertion anomaly would occur.

C.
A deletion anomaly would occur.

D.
Both an insertion anomaly and a deletion anomaly would occur.


Leave a Reply