Online GK Series

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

Database Normalization MCQs | Database Management System Multiple Choice Questions and Answers

Questions
1 A function that has no partial functional dependencies is in _______ form :
A 3NF
B 2NF
C 4NF
D BCNF

Answer: Option [B]
2 4NF is designed to cope with :
A Transitive dependency
B Join dependency
C Multi valued dependency
D None of these

Answer: Option [C]
3 5NF is designed to cope with :
A Transitive dependency
B Join dependency
C Multi valued dependency
D All of the above

Answer: Option [B]
4 A BCNF is :
A loss less join and dependency preserving
B loss less join but not dependency preserving
C not loss less join but dependency preserving
D none of these

Answer: Option [B]
5 Every Boyee-Codd normal form is in
A First normal form
B Second normal form
C Third normal form
D All of the above

Answer: Option [D]

Computer Science Books

Chapters

Please Like Us
Brand