What are two advantages of normalization in a database? (Choose two.)
A.
reduces schema limitations
B.
minimizes impact of data corruption
C.
decreases space used on disk
D.
prevents data inconsistencies
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
A, C
0
0
Answer is B, D
Data corruption is prevented by avoiding Delete, Insert, Update anomalies
Data consistency is preserved by the relational model (look up tables)
Neither space disk or schema design is guaranteed to be impacted favorably by normalization (it often worsens due to required joins, and increased table and column creation)
0
0