____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.
A)optimization
B)fragmentation
C)normalization
D)encapsulation

Question

Quizplus · Accepted Answer

Normalization improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table. This reduces the amount of disk space required and increases the speed and efficiency of data retrieval operations. Optimization refers to the process of improving performance by fine-tuning database parameters and query execution plans. Fragmentation refers to the problem of data becoming scattered across different storage locations, which can affect performance. Encapsulation refers to the concept of hiding implementation details from users, which is not directly related to optimizing database efficiency.

____ Improves Database Efficiency by Eliminating Redundant Data and Ensuring