Current Affairs Quiz 2024GKCourses UGC NETADRE 2.0English

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

Download PDF

Database management system 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
(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

Comment

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

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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

Comment

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

Comment

Answer: Option [B]
(10) A normal form in which every determinant is a key :
[A] 2NF
[B] 3NF
[C] BCNF
[D] 4NF

Comment

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!

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

Chapters

LEAVE A COMMENT