GATE 2011
Consider the relations R(A, B) and S(B, C). Which of the following SQL queries is equivalent to the relational algebra expression π_A (R ⋈ S)?
Related Database Management PYQs
In the Thomas Write Rule concurrency control protocol, what happens when a transaction Ti attempts to write to data item X, and ti…
The division operator (÷) in relational algebra is most naturally used to express queries involving:
A clustered index on a database table can be created on:
Let P, Q, R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context …
In the context of relational database normalization, which of the following statements is/are true?
Consider a relational database schema with two relations R(P,Q) and S(X,Y). Let E = {<u> | there ∃ v, there ∃ w, <u,v> in R and <v…
Free account benefits
Turn practice into measurable progress
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.
Saved progressKeep answers, mock results and completion history across devices.
Adaptive practiceGet questions matched to your recent accuracy and difficulty level.
Bookmarks and notesBuild a personal revision list and record why a question was difficult.
Performance insightsSee weak subjects, accuracy trends, streaks and exam readiness.