Time Left - 15:00 mins

GATE CS 2022: Database- 4

Attempt now to get your rank among 353 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?

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:

Question 6

__________is used to create a new table in the database.
  • 353 attempts
  • 4 upvotes
  • 11 comments
Jul 15GATE & PSU CS

Posted by:

Priya UpadhyayPriya UpadhyayMember since Sep 2020
Priya Upadhyay
Share this quiz   |