JOIN ADRE 2.0 Telegram Group

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

Questions
16 Functional dependencies are a generalization of :
A Key dependencies
B Relation dependencies
C Database dependencies
D None of these

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

Answer: Option [A]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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

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

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

Answer: Option [D]

ADRE 2.0 FULL LENGTH MOCK TEST

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!

Chapters

Advertisement