Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

Get Attractive Job

Database Normalization Objective Type Questions with Answers | Database Management System MCQs

Questions
6 Which one is not true ?
A A relation is in BCNF if it is in 4NF
B BCNF is stricter than 3NF
C A relation is in BCNF if ever determinate of the relation is a candidate key
D All are true

Answer: Option [D]
7 If every non-key attribute is functionally dependent on the primary key, then the relation will be in :
A 1NF
B 2NF
C 3NF
D 4NF

Answer: Option [B]
8 Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then the decomposition is :
A not in 2NF
B in 2NF but not in 3NF
C in 3NF but not in 2NF
D in both 2NF and 3NF

Answer: Option [B]
9 A table is in 2NF if it is in 1NF and if :
A no column that is not a part of the primary key is dependent on only a portion of the alternate key.
B no column that is not a part of the primary key is dependent on only a portion of the primary key
C no column that is not a part of the primary key is dependent on only a portion of the foreign key
D none of these

Answer: Option [B]
10 A normal form in which every determinant is a key :
A 2NF
B 3NF
C BCNF
D 4NF

Answer: Option [C]

Chapters

Useful Computer Science EBooks