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
What are two advantages of normalization in a database?
What are two advantages of normalization in a database? (Choose two.)
A, C
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)