JOIN ADRE 2.0 Telegram Group

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
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 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]

ADRE 2.0 MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

Advertisement