Structured Query Language (SQL) GATE 2015 Question #2703 with Solution

GATE 2015 · Set-3

Database ManagementStructured Query Language (SQL)mediumMCQ1 mark

SQL allows duplicates tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested query shown below: select * from R where a in (select S.a from S)

Aselect R.* from R,S where R.a=S.aBselect distinct R.* from R,S where R.a=S.aCselect R.* from R,(select distinct a from S) as S1 where R.a=S1.aDselect R.* from R,S where R.a=S.a and is unique R

Save your progress

Related Database Management PYQs

GATE 2015 · Set-1

Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary); departments(dept-id,dept-name,ma…

GATE 2015 · Session-1

A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Th…

GATE 2015 · Set-2

In a B+ tree of order d (maximum number of pointers per internal node is d), the minimum number of keys in any non-root internal n…

GATE 2015 · Session-1

SELECT operation in SQL is equivalent to

GATE 2015 · Session-1

Consider an Entity-Relationship (ER) model in which entity sets E1 and E2 are connected by an m:n relationship R12. E1 and E3 are …

GATE 2015 · Session-1

See the question below and answer

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.

Related Database Management PYQs

Turn practice into measurable progress