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.
(16)
Functional dependencies are a generalization of :
[A]
Key dependencies
[B]
Relation dependencies
[C]
Database dependencies
[D]
None of these
Comment
(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
(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
(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
(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
Please share this page
Chapters