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
APSC CCE PRELIMS Mock Test - 1 Start Test
APSC CCE PRELIMS Mock Test - 2 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]

APSC PRELIMS FULL LENGTH MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

apsc cce prelims 2024 test series