Software Development Fundamentals — Question 20

What are two advantages of normalization in a database? (Choose two)

Answer options

• A. prevents data inconsistencies
• B. reduces schema limitations
• C. minimizes impact of data corruption
• D. decreases space used on disk

Correct answer: A, D

Explanation

Normalization is crucial as it helps to avoid data inconsistencies by organizing data efficiently. Additionally, it often results in decreased disk space usage by eliminating redundancy. The other options, while important, do not directly relate to the primary advantages of normalization.