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
ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 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 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

Advertisement