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

(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

Article and Schedule Quiz Start Test!
(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]

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