DBMS- Normalization Questions and Answers
Normalization in DBMS is a process used to organize data efficiently and remove redundancy. This topic is a key part of DBMS interview questions and answers and frequently appears in placement exams by TCS, Accenture, Infosys, and Wipro. In this article on DBMS Normalization questions with answers, you’ll learn about different normal forms (1NF, 2NF, 3NF, BCNF) and how they improve database design. Questions typically test your understanding of functional dependencies, decomposition, and anomaly prevention. Practicing Database programming MCQs with clear explanations helps you strengthen both theoretical and practical knowledge needed for interviews and university exams. Use this section as a quick revision tool and practice resource before your next placement or test.
DBMS- Normalization
11. Multi-valued dependencies are the result of 1NF, which prohibited an attribute from having a set of values.
- TRUE
- FALSE
13. Normalization is formal process of developing data structure in a manner that eliminates redundancy and promites integrity.
- TRUE
- FALSE
15. Normalization is a process of
- decomposing a set of relations
- successive reduction of relation schema.
- deciding which attributes in relation to be
- all of these
16. The normalization process was developed by
- E. F. Codd
- R. F. Boyce
- R. Fagin
- Collin White
17. A normal form is
- a state of a relation that results from applying simple rules regarding FDs.
- the highest normal form condition that it meets
- an indication of the degree to which it has been normalised
- all of these.
18. Which of the following is the formal process of deciding which attributes should be grouped together in a relation ?
- optimization
- normalization
- turning
- none of these
19. In 1NF,
- all domains are simple
- in a simple domain, all elements are atomic
- both (a) & (b)
- None of these