Q: What is the primary goal of normalization in the logical database design process? [Question 2]

A To eliminate data redundancy
B To establish access control to the database objects
C To optimize query performance
D To define the physical data structures within the database

Share this MCQ

Answer: A

Explanation:

The goal of normalization in the logical database design process is to eliminate data redundancy.
Redundant data can lead to data inconsistencies and anomalies when performing insertions, updates, and deletions.
By applying normalization techniques, redundant data is eliminated, and data is structured in a way that ensures each piece of information is stored only once, maintaining data integrity and consistency.

Database Concepts MCQs

Share Above MCQ

‹ Previous Next ›

Write your comment

Learn More MCQ Questions from DataBase Management System Database Concepts MCQs

Q: What is the primary goal of normalization in the logical database design process? [Question 2]

Report Question