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

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!

Chapters

Advertisement