Data and Database Administration
Q. What does normalization aim to achieve?
-
A.
Reduce data redundancy
-
B.
Increase data integrity
-
C.
Simplify database design
-
D.
All of the above
Solution
Normalization aims to achieve all of the above by organizing data to minimize redundancy and dependency.
Correct Answer: D — All of the above
Q. What is denormalization?
-
A.
The process of reducing redundancy
-
B.
The process of increasing redundancy
-
C.
The process of normalizing data
-
D.
The process of creating indexes
Solution
Denormalization is the process of increasing redundancy in a database to improve read performance by reducing the number of joins needed.
Correct Answer: B — The process of increasing redundancy
Showing 1 to 2 of 2 (1 Pages)
