Database Management System - DBMS Solved 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]

Article and Schedule Quiz	Start Test!

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]

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!