1

GATE CSE 2014 Set 2

Numerical

+1

-0

The maximum number of superkeys for the relation schema $$R(E, F, G, H)$$ with $$E$$ as key is ______.

Your input ____

2

GATE CSE 2014 Set 2

MCQ (Single Correct Answer)

+2

-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)`

3

GATE CSE 2014 Set 2

MCQ (Single Correct Answer)

+2

-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 if4

GATE CSE 2014 Set 2

MCQ (Single Correct Answer)

+2

-0.6

Consider the following schedule S of transactions T1, T2, T3, T4:

Paper analysis

Total Questions

Algorithms

5

Compiler Design

2

Computer Networks

6

Computer Organization

5

Data Structures

3

Database Management System

5

Digital Logic

3

Discrete Mathematics

9

Operating Systems

4

Programming Languages

5

Software Engineering

1

Theory of Computation

5

More papers of GATE CSE

GATE CSE 2024 Set 2

GATE CSE 2024 Set 1

GATE CSE 2023

GATE CSE 2022

GATE CSE 2021 Set 2

GATE CSE 2021 Set 1

GATE CSE 2020

GATE CSE 2019

GATE CSE 2018

GATE CSE 2017 Set 1

GATE CSE 2017 Set 2

GATE CSE 2016 Set 2

GATE CSE 2016 Set 1

GATE CSE 2015 Set 1

GATE CSE 2015 Set 2

GATE CSE 2015 Set 3

GATE CSE 2014 Set 1

GATE CSE 2014 Set 3

GATE CSE 2014 Set 2

GATE CSE 2013

GATE CSE 2012

GATE CSE 2011

GATE CSE 2010

GATE CSE 2009

GATE CSE 2008

GATE CSE 2007

GATE CSE 2006

GATE CSE 2005

GATE CSE 2004

GATE CSE 2003

GATE CSE 2002

GATE CSE 2001

GATE CSE 2000

GATE CSE 1999

GATE CSE 1998

GATE CSE 1997

GATE CSE 1996

GATE CSE 1995

GATE CSE 1994

GATE CSE 1993

GATE CSE 1992

GATE CSE 1991

GATE CSE 1990

GATE CSE 1989

GATE CSE 1988

GATE CSE 1987

GATE CSE
Papers

2023

2022

2020

2019

2018

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

1996

1995

1994

1993

1992

1991

1990

1989

1988

1987