Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

Functional Dependency Objective Type Questions and Answers | Database Management System MCQs

Download PDF

Database management system objective questions and answers page contain 5 questions from chapter Functional dependencies. Each mcq has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(16) Functional dependencies are a generalization of :
[A] Key dependencies
[B] Relation dependencies
[C] Database dependencies
[D] None of these

Comment

Answer: Option [A]
(17) R(A,B,C,D) is a relation, Which of the following does not have a lossless join dependency preserving BCNF decomposition
[A] A→B, B→CD
[B] A→B, B→C, C→D
[C] AB→C, C→AD
[D] A→BCD

Comment

Answer: Option [A]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(18) A property which ensures that each functional dependency is represented in some individual relational resulting after decomposition
[A] Loss less join
[B] Dependency preservation
[C] Both [A] and [B]
[D] None of the above

Comment

Answer: Option [C]
(19) A functional dependency of the form X→Y is trivial if
[A] X⊆X
[B] Y⊂X
[C] X⊆Y
[D] X⊂Y and Y⊂X

Comment

Answer: Option [B]
(20) Consider the following set of functional dependencies on the scheme (A, B, C)

The canonical cover for this set is

A→BC
B→C
A→B
AB→C
[A] A→BC and B→C
[B] A→BC and AB→C
[C] A→BC and A→B
[D] A→B and B→C

Comment

Answer: Option [D]

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