Time Left - 15:00 mins

GATE CS 2021 : Database Quiz 5

Attempt now to get your rank among 700 students!

Question 1

Which of the following tuple relational calculus expression(s) is/are equivalent to ?
I.
II.
III.
IV.

Question 2

The relational algebra expression equivalent to the following tuple calculus relation:

}

Question 3

Consider the two relational database:
Enroll (Sid, Cid, Grade)
Course (Cid, Cname, Inst)
Consider the two given TRC queries:
S1:
S2:
Which of the following result into sid which are enrolled in some course taught by KORTH?

Question 4

Write a relational algebra expression to satisfy the following query.
“Get Emp# of employees working on project NET353”

Question 5

An expression in the domain relational calculus is of the form

Question 6

Find all students who have taken all courses offered in the Biology department.” The expressions that matches this sentence is :

  • 700 attempts
  • 7 upvotes
  • 7 comments
Sep 24GATE & PSU CS

Posted by:

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