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
APSC CCE PRELIMS Mock Test - 1 Start Test
APSC CCE PRELIMS Mock Test - 2 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]

APSC PRELIMS FULL LENGTH MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

apsc cce prelims 2024 test series