GkSeries.com

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

Download PDF

Database management system multiple choice questions and answers page contain 5 questions from chapter Database Normalization. Each objective question has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(1) A function that has no partial functional dependencies is in _______ form :
[A] 3NF
[B] 2NF
[C] 4NF
[D] BCNF

Comment

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

Comment

Answer: Option [C]

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

Comment

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

Comment

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

Comment

Answer: Option [D]

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test