Database Normalization Objective Type Questions and Answers

Questions

6 Which one is not true ?

A A relation is in BCNF if it is in 4NF

B BCNF is stricter than 3NF

C A relation is in BCNF if ever determinate of the relation is a candidate key

D All are true

Answer: Option [D]

7 If every non-key attribute is functionally dependent on the primary key, then the relation will be in :

A 1NF

B 2NF

C 3NF

D 4NF

Answer: Option [B]

Article and Schedule Quiz	Start Test!

8 Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then the decomposition is :

A not in 2NF

B in 2NF but not in 3NF

C in 3NF but not in 2NF

D in both 2NF and 3NF

Answer: Option [B]

9 A table is in 2NF if it is in 1NF and if :

A no column that is not a part of the primary key is dependent on only a portion of the alternate key.

B no column that is not a part of the primary key is dependent on only a portion of the primary key

C no column that is not a part of the primary key is dependent on only a portion of the foreign key

D none of these

Answer: Option [B]

10 A normal form in which every determinant is a key :

A 2NF

B 3NF

C BCNF

D 4NF

Answer: Option [C]

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!