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]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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]

Chapters

apsc complete general studies course