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.

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 (

Course (

Consider the two given TRC queries:

S1:

S2:

Which of the following result into sid which are enrolled in some course taught by KORTH?

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”

“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

Tags :

GATE & PSU CSDatabasesSep 24GATE & PSU CS

Posted by: