JOIN ADRE 2.0 Telegram Group

Database Management System MCQs | DBMS Solved Objective Questions and Answers on Normalization

Questions
11 Third normal form is based on the concept of _________
A Closure Dependency
B Transitive Dependency
C Normal Dependency
D Functional Dependency

Answer: Option [B]
12 Third normal form is inadequate in situations where the relation :
A has multiple candidate keys
B has candidate keys that are composite
C has overlapped candidate keys
D none of the above

Answer: Option [D]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

13 Which of the following statements is/are true ?
A A relation is in BCNF if it is not in 4NF
B BCNF is stricter than 3NF
C A relation is in BCNF if every determinant of the relation is a candidate key.
D All are true

Answer: Option [D]
14 Which normal form is considered as adequate for usual database design ?
A 2NF
B 3NF
C 4NF
D 5NF

Answer: Option [B]
15 Which of the following is true ?
A A relation in BCNf is always in 3NF.
B A relation in 3NF is always in BCNF.
C BCNF and 3NF are same.
D A relation in BCNF is not in 3NF

Answer: Option [A]

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