Time Left - 15:00 mins
GATE CS 2021 : Database Quiz 5
Attempt now to get your rank among 710 students!
Question 1
Which of the following tuple relational calculus expression(s) is/are equivalent to
?
I.
II.
III.
IV.![](https://gs-question-images.grdp.co/1447152072181712.png)
![](https://gs-question-images.grdp.co/1447152069289127.png)
I.
![](https://gs-question-images.grdp.co/1447152069991827.png)
II.
![](https://gs-question-images.grdp.co/144715207068381.png)
III.
![](https://gs-question-images.grdp.co/1447152071387988.png)
IV.
![](https://gs-question-images.grdp.co/1447152072181712.png)
Question 2
The relational algebra expression equivalent to the following tuple calculus relation:
is?
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?
Enroll (Sid, Cid, Grade)
Course (Cid, Cname, Inst)
Consider the two given TRC queries:
S1:
![](https://gradeup-question-images.grdp.co/liveData/PROJ20931/1535967074763757.png)
S2:
![](https://gradeup-question-images.grdp.co/liveData/PROJ20931/1535967075493275.png)
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 :
- 710 attempts
- 7 upvotes
- 7 comments
Tags :
GATE & PSU CSDatabasesAug 3GATE & PSU CS