Skip to content

GATE CS Tuple Calculus and SQL questions

Practise Tuple Calculus and SQL questions for GATE CS. Explore official PYQs and original topic-wise quizzes, check answers and view available solutions. Free, no sign-in.

Subject, topic, year and type filter the full library. Match any choice within a filter, and all selected filter categories. Search, source and sort apply to this page.

7 on this page
Official PYQ2001DatabasesTuple Calculus and SQLMCQ · 1 mark
Consider a relation geq which represents "greater than or equal to", that is, (x,y)∈(x,y) \in geq only if y≥xy \geq x. create table geq ( ib integer not null, ub integer not null, primary key ib, foreign key (ub) references geq on delete cascade ); Which of the following is possible if tuple (x,y) is deleted?
Official PYQ2001DatabasesTuple Calculus and SQLMCQ · 1 mark
Which of the following relational calculus expression is not safe?
Official PYQ2000DatabasesTuple Calculus and SQLMCQ · 1 mark
In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparisons with a null value are treated as false. Which of the following pairs is not equivalent?
Official PYQ2000DatabasesTuple Calculus and SQLMCQ · 1 mark
Given relations r(w, x) and s(y, z) the result of select distinct w, x from r, s is guaranteed to be same as r, provided.
Official PYQ1999DatabasesTuple Calculus and SQLMCQ · 1 mark
Which of the following is/are correct?
Official PYQ1999DatabasesTuple Calculus and SQLMCQ · 1 mark
The relational algebra expression equivalent to the following tuple calculus expression: {t∣t∈r∧(t[A]=10∧t[B]=20)}\left\{t \mid t \in r \land \left(t[A] = 10 \land t[B]=20\right)\right\} is
Official PYQ1998DatabasesTuple Calculus and SQLMCQ · 1 mark
Which of the following query transformations (i.e., replacing the l.h.s. expression by the r.h.s expression) is incorrect? R1 and R2 are relations, C1 and C2 are selection conditions and A1 and A2 are attributes of R1.