Time Left - 15:00 mins

GATE CS 2022: Database- 2

Attempt now to get your rank among 244 students!

Question 1

Consider a relation R (A, B, C, D, E) with the following functional dependencies:

ABC  DE

D  AB

The number of super keys of R is:

Question 2

Which of the following statements about normal forms is false?

Question 3

From the following instance of relational schema R (A, B, C), We can conclude that:

Question 4

In domain relational calculus "there exist" can be represented as-

Question 5

Consider a relation R (A, B, C, D, E) with the following functional dependencies:

A BC

C E

B D

E A

The total numbers of super keys present in the relation are _______.

Question 6

For the given relation R (ABCDE) with the following functional dependencies

F= {A→BC, B→D, CD→E, E→A}

The number of candidate keys are____________.

  • 244 attempts
  • 0 upvotes
  • 3 comments
Jul 13GATE & PSU CS

Posted by:

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