Time Left - 15:00 mins
GATE CS 2022: Database- 4
Attempt now to get your rank among 394 students!
Question 1
A functional dependency set:
F = {A → B, BC → E, ED → A, EF → G, E → F}
Find the closure of (AC)?
Question 2
Find the attribute closures of given FDs R(ABCDE)
{AB->C,
B->D,
C->E,
D->A}
Which of the following is true?
{AB->C,
B->D,
C->E,
D->A}
Which of the following is true?
Question 3
Find the candidate key of the following relation R, where functional dependencies(FD) are given as
R={ A,B,C,D,E}
FD={ AB-->C, BC-->AD, D-->E, CE-->B}
Choose the correct option from below.
Question 4
Suppose there is a relation R with the following attributes:
R = {A,B,C,D}
The functional dependencies are
FD = {AB-->C, C-->B, C-->D}
Choose the correct option from the below which defines a candidate key of above relation.
a) AB
b) AC
c) BC
d) A
Choose the correct code:
Question 5
Which of the following is Data Definition Language command?
Question 6
__________is used to create a new table in the database.
- 394 attempts
- 4 upvotes
- 13 comments
Tags :
GATE & PSU CSDatabasesAug 5GATE & PSU CS