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

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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]

Random GK Questions

Q. Which state is the largest producer of sugarcane in India ?
Q. The writ of Habeas Corpus is issued in the event of
Q. Which of the following substances or chemicals is obtaind from plants?
Q. Odissi classical dance originated in :
Q. Sea caves are a creation of
Q. When the Indian Muslim League was inducted into the interim government in 1946, Liyaquat Ali Khan was assigned the portfolio of:

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics