Structured Query Language (SQL) GATE 2014 Question #9950 with Solution

GATE 2014 · session-2

Database ManagementStructured Query Language (SQL)mediumMCQ2 marks

SQL allows duplicate 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 2014 · SET - 1

Consider the following schedule S involving two transactions T1 and T2: S: r1(X); r2(X); w1(X); r2(Y); w2(X); c1; c2; Which of the…

GATE 2014 · SET - 2

A relation R(A, B, C) has functional dependencies F = {A -> B, B -> C}. If R is decomposed into R1(A, B) and R2(B, C), this decomp…

GATE 2014 · SET - 1

Consider a schema R(A, B, C, D) with functional dependencies F = {AB -> C, C -> D, D -> A}. What are all the candidate keys of R?

GATE 2014 · session-1

Consider the relation scheme R=(E,F,G,H,I,J,K,L,M,N) and the set of functional dependencies {{E,F}→{G}, {F}→{I,J}, {E,H}→{K,L}, {K…

GATE 2014 · session-1

Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: …

GATE 2014 · session-1

Consider the following four schedules due to three transactions (indicated by the subscript) using read and write on a data item x…

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