1. : What is the main purpose of normalization in databases?
(A) To increase redundancy
(B) To reduce data redundancy and improve data integrity
(C) To speed up the internet
(D) To add more tables unnecessarily
2. : Which normal form eliminates repeating groups of data?
(A) 1st Normal Form (1NF)
(B) 2nd Normal Form (2NF)
(C) 3rd Normal Form (3NF)
(D) Boyce-Codd Normal Form (BCNF)
3. : Partial dependency is removed in which normal form?
(A) 1NF
(B) 2NF
(C) 3NF
(D) BCNF
4. : Transitive dependency is removed in:
(A) 1NF
(B) 2NF
(C) 3NF
(D) 4NF
5. : Which of the following best defines data integrity?
(A) Keeping data private only
(B) Maintaining accuracy, consistency, and reliability of data
(C) Speeding up database queries
(D) Making data accessible offline
6. : Which type of integrity ensures that a table’s primary key is unique and not NULL?
(A) Entity Integrity
(B) Referential Integrity
(C) Domain Integrity
(D) Relational Integrity
7. : Referential integrity is maintained using:
(A) Primary keys only
(B) Foreign keys
(C) Composite keys only
(D) Candidate keys
8. : Which of the following is an example of domain integrity?
(A) A student’s age must be a positive integer
(B) A foreign key matches the primary key in another table
(C) Each row in a table must be unique
(D) A record cannot exist without a primary key
9. : In normalization, which normal form ensures there are no multivalued dependencies?
(A) 1NF
(B) 2NF
(C) 3NF
(D) 4NF
10. : What is the main drawback of excessive normalization?
(A) Increased data redundancy
(B) Complexity and slower query performance due to too many tables
(C) Inconsistency in data
(D) Loss of data integrity