Time Left - 15:00 mins

GATE 2022: Database Management system Quiz-5

Attempt now to get your rank among 289 students!

Question 1

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

Question 2

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

Question 3

Consider the following schema:

Student(Sid, Sname, Sgender, Cid)

Class(Cid,Cname)

Which of the following correctly represent the statement:

“Classes that are attended by male students”

Question 4

What the following relational calculus represents?
{t|s supp(t[s_name]=s[s_name]^
u supp(u[s_address]=s[s_address]^
u[s_name]=”tarun”))}

Question 5

How many of the following statements are true?

A) Relational calculus is equivalent to relational algebra in its capabilities.

B) Relational calculus is stronger than relational algebra.

C) Relational calculus is weaker than relation algebra

D) It is based on predicate calculus of formal logic.

Question 6

Suppose R is a table with 4 attributes A,B, C and D, and S be a table with 3 attributes B, E, F. Now given a particular instance of R and S.

S is empty, having no tuples. What is the correct no of tuples in the Result of given Query _____

  • 289 attempts
  • 2 upvotes
  • 0 comments
Sep 30GATE & PSU CS