Which of the following is used to reduce data redundancy in databases?
A
Replication
B
Indexing only
C
Normalization
D
Denormalization
Correct Answer: Option C — Normalization
Explanation:
Normalization is a database design technique used to organize tables in a way that reduces data redundancy and improves data integrity. It involves dividing large tables into smaller, related tables and defining relationships between them.