JOIN ADRE 2.0 Telegram Group

Database Normalization Objective Type Questions with Answers | Database Management System MCQs

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

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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]

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
Assam Direct Recruitment Test Series