Join our Telegram Channel

8000+ STATIC GK MCQs for SSC/ Railway/ PSC
1000 POLITICAL SCIENCE MCQS | EBook
Get 22 nos. GK EBooks | Combo Pack
Current Affairs Monthly Magazine -Subscribe Now!
1000 BIOLOGY MCQS AND ANSWERS | EBook
1000 ECONOMICS MCQS FOR EXAMS | EBook
Mughal Empire MCQs | EBook
ECONOMIC GEOGRAPHY MCQs | EBook
350 MCQs ON INDIAN CONSTITUTION | EBook

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]
Advertisement
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]
Advertisement

Chapters

General Knowledge

Month-wise Current Affairs 2022

Category-wise Current Affairs

Jobs by Qualification

Free Mock Test