Normalization of database is used to

  1. Eliminate redundancy.

  2. Improve security.

  3. Improve efficiency.

  4. Minimize Errors.


Correct Option: A
Explanation:

Normalization of a database is used to eliminate redundancy and improve efficiency.

A. Eliminate redundancy: This option is correct. One of the main goals of database normalization is to eliminate or reduce redundancy in order to improve data consistency and reduce storage requirements. Redundancy can lead to data inconsistencies and inefficiencies in data management.

B. Improve security: This option is not directly related to normalization. While normalization can indirectly improve security by ensuring data integrity and reducing the risk of data inconsistencies, it is not its primary purpose.

C. Improve efficiency: This option is correct. Normalization helps improve the efficiency of data storage, retrieval, and manipulation operations by organizing data into properly structured tables and reducing data redundancy. This can lead to faster and more efficient query execution.

D. Minimize errors: This option is partially correct. Normalization can help minimize errors by reducing redundancy and ensuring data consistency. However, it is not its sole purpose, as efficiency and elimination of redundancy are also important goals.

Therefore, the correct answer is:

A. Eliminate redundancy.

Find more quizzes: