Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

Database Management System MCQs | DBMS Solved Objective Questions and Answers on Normalization

Download PDF

DBMS objective questions and answers page contain 5 questions from chapter Database Normalization. Each mcq has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(11) Third normal form is based on the concept of _________
[A] Closure Dependency
[B] Transitive Dependency
[C] Normal Dependency
[D] Functional Dependency

Comment

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

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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

Comment

Answer: Option [D]
(14) Which normal form is considered as adequate for usual database design ?
[A] 2NF
[B] 3NF
[C] 4NF
[D] 5NF

Comment

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

Comment

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!

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

LEAVE A COMMENT