Current Affairs 2021 PDF

To crack any competitive exam like SSC, Railways, Insurance, UPSC, CLAT, Banking, State PSC Exams and other exams it is very important to answer all current affairs questions correctly. Gkseries Updates Current Affairs and Q&A packages in compiled and sorted topic wise to ensure easy accessibility of the information.

Buy Now

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]
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

Month-wise Current Affairs 2021

Category-wise Current Affairs

Jobs by Qualification

Free Mock Test