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]

⭐ Make GKSeries Your Preferred Source on Google

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]