MySQL - Normalization MCQ

MySQL – Normalization MCQ

1 / 26

1. What is the primary goal of database normalization?

To improve query performance

To add more columns to tables

To increase data redundancy

To complicate the database structure

2 / 26

2. Which normalization form ensures that data is in its most reduced and efficient form?

5NF

2NF

BCNF

1NF

3 / 26

3. What is the main principle behind normalization?

Data integrity

Data redundancy

Data compression

Data duplication

4 / 26

4. In which normalization form is a table not allowed to have partial dependencies on the primary key?

1NF

2NF

4NF

3NF

5 / 26

5. What is a candidate key in the context of database normalization?

A key used to unlock data

A key that is not used in normalization

A key used to identify data

A key that could potentially be a primary key

6 / 26

6. What is the purpose of eliminating redundancy in a database?

To simplify query optimization

To increase data consistency

To complicate data retrieval

To reduce storage space

7 / 26

7. Which normalization form ensures that there are no transitive dependencies between non-key attributes?

4NF

2NF

1NF

3NF

8 / 26

8. In a well-normalized database, what happens when data is updated in one place?

Data is deleted

Data becomes inconsistent

Data is duplicated in multiple places

Data remains the same

9 / 26

9. What is the key idea behind the First Normal Form (1NF)?

Data duplication

Partial dependency

Atomicity of data

Data compression

10 / 26

10. Which normal form is often the minimum requirement for a well-structured database?

1NF

2NF

BCNF

3NF

11 / 26

11. In Second Normal Form (2NF), what should be ensured regarding non-key attributes?

They should be independent of the primary key

They should be fully functionally dependent on the primary key

They should be partially dependent on the primary key

They should be stored in a separate table

12 / 26

12. What is a superkey in the context of database normalization?

A key that unlocks any data

A key that is a subset of the primary key

A key that is not used in normalization

A key that is a superset of the primary key

13 / 26

13. What is the goal of Boyce-Codd Normal Form (BCNF)?

To improve data integrity

To simplify query optimization

To eliminate data duplication

To increase data redundancy

14 / 26

14. What is the primary benefit of a well-normalized database for query performance?

Slower query execution

More storage space required

Increased data redundancy

Faster query execution

15 / 26

15. In which normalization form are multi-valued dependencies addressed?

4NF

5NF

BCNF

3NF

16 / 26

16. What is the main reason to avoid over-normalization in database design?

It simplifies query optimization

It improves data integrity

It reduces storage space

It increases data redundancy

17 / 26

17. What term describes a situation where data is inserted, updated, or deleted in a way that causes data inconsistencies?

Data integrity issue

Data anomaly

Data duplication

Data normalization

18 / 26

18. What is the primary focus of normalization?

To increase data storage capacity

To eliminate data redundancy

To maximize data duplication

To reduce query complexity

19 / 26

19. What type of dependencies does normalization aim to eliminate in a database?

Partial dependencies

Functional dependencies

Multi-valued dependencies

Logical dependencies

20 / 26

20. What is the most basic form of normalization?

BCNF

3NF

2NF

1NF

21 / 26

21. What does the term “atomicity of data” refer to in normalization?

Data consistency

Data duplication

Data redundancy

Data being indivisible

22 / 26

22. In which normalization form are tables organized to ensure there are no repeating groups or arrays?

2NF

BCNF

1NF

3NF

23 / 26

23. What is the ultimate goal of normalization in a database?

To maximize data redundancy

To improve data consistency

To reduce data duplication

To increase data storage capacity

24 / 26

24. What does the term “transitive dependency” refer to in normalization?

When a primary key depends on a non-key attribute

When a non-key attribute depends on another non-key attribute

When data is updated consistently

When data is stored in multiple places

25 / 26

25. Which of the following is not a benefit of database normalization?

Improved data integrity

Reduced data duplication

Increased data redundancy

Simplified query optimization

26 / 26

26. What is the main disadvantage of over-normalization in database design?

Enhanced data integrity

Increased data redundancy

Complex and slow queries

Improved query performance

Your score is