CIW
1D0-441 · Question #141
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
- ANo adverse effects would occur on the database.
- BAn insertion anomaly would occur.
- CA deletion anomaly would occur.
- DAn update anomaly and a deletion anomaly would occur.
How the community answered
(43 responses)- A5% (2)
- B16% (7)
- C72% (31)
- D7% (3)
Community Discussion
No community discussion yet for this question.
