- A To ensure data consistency and integrity
- B To define access control to database objects
- C To optimize query performance
- D To determine the physical storage allocation of the database
- Share this MCQ
Answer:
A
Explanation: The primary goal of normalization is to ensure that each elementary "fact" is recorded in only one place within the database.
This helps maintain data consistency and integrity by preventing data duplication and anomalies.
Normalization eliminates redundant data and structures the database in a way that allows for efficient insertions, updates, and deletions while maintaining the accuracy and consistency of the data. Click me to Read more Question & Answer of Database Concepts MCQs
Share this MCQ
Answer:A) To ensure data consistency and integrity
Explanation: The primary goal of normalization is to ensure that each elementary "fact" is recorded in only one place within the database.
This helps maintain data consistency and integrity by preventing data duplication and anomalies.
Normalization eliminates redundant data and structures the database in a way that allows for efficient insertions, updates, and deletions while maintaining the accuracy and consistency of the data. Click me to Read more Question & Answer of Database Concepts MCQs
Share this MCQ