CIW
1D0-541 · Question #105
The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student…
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 Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?
Exhibit
Options
- AOnly an update anomaly would occur.
- BAn insertion anomaly would occur.
- CA deletion anomaly would occur.
- DAn update anomaly and a deletion anomaly would occur.
How the community answered
(60 responses)- A13% (8)
- B7% (4)
- C75% (45)
- D5% (3)
Community Discussion
No community discussion yet for this question.