GATE CSE 2014 Set 2 | GATE CSE Year Wise Previous Years Questions

GATE CSE 2014 Set 2

MCQ (Single Correct Answer)

-0.6

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)

Select R.* from R, S where R.a = S.a

Select distinct R.* from R, S where R.a = S.a

Select R.* from R, (select distinct a from S) as S1 where R.a = S1.a

Select R.* from R, S where R.a = S.a and is unique R

GATE CSE 2014 Set 2

MCQ (Single Correct Answer)

-0.6

Consider a join (relation algebra) between relations r(R)and s(S) using the nested loop method. There are 3 buffers each of size equal to disk block size, out of which one buffer is reserved for intermediate results. Assuming size(r(R)) < size(s(S)), the join will have fewer number of disk block accesses if

relation r(R) is in the outer loop.

relation s(S) is in the outer loop.

join selection factor between r(R) and s(S) is more than 0.5.

join selection factor between r(R) and s(S) is less than 0.5.

GATE CSE 2014 Set 2

MCQ (Single Correct Answer)

-0.6

Consider the following schedule S of transactions T1, T2, T3, T4: GATE CSE 2014 Set 2 Database Management System - Transactions and Concurrency Question 14 English

GATE CSE 2014 Set 2 Database Management System - Transactions and Concurrency Question 14 English

S is conflict-serializable but not recoverable

S is not conflict-serializable but is recoverable

S is both conflict-serializable and recoverable

S is neither conflict-serializable not is it recoverable

GATE CSE 2014 Set 2

Numerical

-0

Consider the equation $${\left( {123} \right)_5} = {\left( {x8} \right)_y}$$ with $$x$$ and $$y$$ as unknown. The number of possible solutions is _________.

Your input ____

PREVIOUS NEXT

GATE CSE Papers

2023