CIW v5 Database Design Specialist 1D0-541 Question # 16 Topic 2 Discussion

CIW v5 Database Design Specialist 1D0-541 Question # 16 Topic 2 Discussion

1D0-541 Exam Topic 2 Question 16 Discussion:
Question #: 16
Topic #: 2

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?

1D0-541 Question 16


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.


Get Premium 1D0-541 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.