Database Fundamentals — Question 62

Denormalization is performed in order to:

Answer options

• A. Reduce redundancy.
• B. Eliminate repeating groups.
• C. Create smaller tables.
• D. Improve query performance.

Correct answer: D

Explanation

The correct answer is D because denormalization typically aims to improve query performance by reducing the number of joins needed when accessing data. Options A, B, and C are incorrect as denormalization often increases redundancy, may create repeating groups, and does not necessarily lead to smaller tables.