CIW
1D0-541 · Question #34
Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any…
The correct answer is B. An insertion anomaly would occur. See the full explanation below for the reasoning.
Question
Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?
Exhibit
Options
- AAn update anomaly and an insertion anomaly would occur.
- BAn insertion anomaly would occur.
- CA deletion anomaly would occur.
- DA deletion anomaly and an update anomaly would occur.
How the community answered
(45 responses)- A2% (1)
- B80% (36)
- C7% (3)
- D11% (5)
Community Discussion
No community discussion yet for this question.