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
21. A relation R is said to be in 2NF
- if it is in 1NF
- every non-prime key attributes of R is fully functionally dependent on each relation key of R.
- if it is in BCNF
- both (a) and (b)
22. A relation R is said to be in 3NF if the
- relation R is in 2NF
- nonprime attributes are mutually independent
- functionally dependent on the primary key.
- all of these.
23. The idea of multi-valued dependency was introduced by
- E.F. Codd
- R.F. Boyce
- R. Fagin
- none of these
24. The expansion of BCNF is
- Boyd-Codd Normal Form
- Boyce-Ccromwell Normal Form
- Boyce-Codd Normal Form
- none of these
25. The fourth normal form (4NF) is concerned with dependencies between the elements of compound keys composed of
- one attribute
- two attributes
- three or more attributes
- none of these
26. When all the columns (attributes) in a relation describe and depend upton the primary key, the relation is said to be in
- 1NF
- 2NF
- 3NF
- 4NF