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

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
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]

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics