Normalization remains one of the most important and frequently asked topics in DBMS for competitive examinations like NIC, TRE, Banking, SSC, and other technical recruitment tests. Candidates are advised to have a clear conceptual understanding as well as problem-solving ability in this area.
In the ever-evolving landscape of computer-based competitive examinations such as NIC, TRE, and various Banking exams, Database Management System (DBMS) continues to be a high-weightage subject. Among its core topics, Normalization has emerged as a frequently tested and conceptually important area, especially in technical and IT-related papers.
Total Questions : 15
Timer : sec
Question : Which of the following is NOT a basic Armstrong’s axiom?
Question : If X → YZ holds, which of the following must also be true?
Question : Which inference rule is derived using both augmentation and transitivity?
Question :
Given:
X → Y and YZ → W
Which of the following can be inferred?
Question : Which of the following statements correctly applies the augmentation rule?
Question :
Consider a relation R(A, B, C) with functional dependencies:
A → B and B → C.
Which normal form is violated?
Question : Which statement correctly differentiates BCNF from 3NF?
Question : Which of the following anomalies is NOT directly reduced by normalization?
Question : A relation is in Third Normal Form (3NF) if it:
Question : Which of the following best describes Second Normal Form (2NF)?
Question : Which of the following violates functional dependency?
Question :
Given FD: (A, B) → C
If A → C also holds, then (A, B) → C is:
Question :
Consider relation R(A, B, C) with FDs:
A → B and B → A
Which statement is correct?
Question : Which of the following functional dependencies is completely non-trivial?
Question :
Given a relation R(A, B, C, D) with functional dependencies:
A → B, B → C, C → D
Which of the following is correct?