Database Management System MCQs | DBMS Solved Objective Questions and Answers on Normalization

  3. solved questions on database normalization
Questions
11 Third normal form is based on the concept of _________
A Closure Dependency
B Transitive Dependency
C Normal Dependency
D Functional Dependency

Answer: Option [B]
12 Third normal form is inadequate in situations where the relation :
A has multiple candidate keys
B has candidate keys that are composite
C has overlapped candidate keys
D none of the above

Answer: Option [D]
13 Which of the following statements is/are true ?
A A relation is in BCNF if it is not in 4NF
B BCNF is stricter than 3NF
C A relation is in BCNF if every determinant of the relation is a candidate key.
D All are true

Answer: Option [D]
14 Which normal form is considered as adequate for usual database design ?
A 2NF
B 3NF
C 4NF
D 5NF

Answer: Option [B]
15 Which of the following is true ?
A A relation in BCNf is always in 3NF.
B A relation in 3NF is always in BCNF.
C BCNF and 3NF are same.
D A relation in BCNF is not in 3NF

Answer: Option [A]

Chapters

gkseries ebooks