1
GATE CSE 2022
MCQ (More than One Correct Answer)
+1
-0.33

Consider the following three relations in a relational database.

Employee ( $$\underline {eld}$$ , Name), Brand ( $$\underline {bld}$$ , bName), Own ( $$\underline {eld}$$ , $$\underline {bld}$$)

Which of the following relational algebra expressions return the set of elds who own all the brands?

A
$$\pi$$eld ($$\pi$$eld, bld (Own) / $$\pi$$bld (Brand))
B
$$\pi$$eld (Own) $$-$$ $$\pi$$eld (($$\pi$$eld (Own) $$\times$$ $$\pi$$bld (Brand)) $$-$$ $$\pi$$eld, bld (Own))
C
$$\pi$$eld ($$\pi$$eld, bld (Own) / $$\pi$$bld (Own))
D
$$\pi$$eld (($$\pi$$eld (Own) $$\times$$ $$\pi$$bld (Own) / $$\pi$$bld (Brand))
2
GATE CSE 2022
Numerical
+1
-0.33

Consider a relation R(A, B, C, D, E) with the following three functional dependencies.

AB $$\to$$ C ; BC $$\to$$ D ; C $$\to$$ E;

The number of superkeys in the relation R is _________.

3
GATE CSE 2022
+1
-0.33

Let Ri(z) and Wi(z) denote reac and write operations on a data element z by a transaction Ti, respectively. Consider the schedule S with four transactions.

S : R4(x), R2(x), R3(x), R1(y), W1(y), W2(x), W3(y), R4(y)

Which one of the following serial schedules is conflict equivalent to S?

A
T1 $$\to$$ T3 $$\to$$ T4 $$\to$$ T2
B
T1 $$\to$$ T4 $$\to$$ T3 $$\to$$ T2
C
T4 $$\to$$ T1 $$\to$$ T3 $$\to$$ T2
D
T3 $$\to$$ T1 $$\to$$ T4 $$\to$$ T2
4
GATE CSE 2022
Numerical
+1
-0.33

Consider the relational database with the following four schemas and their respective instances.

Student( $$\underline {sNo}$$ , sName, dNo) Dept( $$\underline {dNo}$$ , dName)

Course( $$\underline {cNo}$$ , cName, dNo) Register( $$\underline {sNo}$$ , $$\underline {cNo}$$ )

SQL Query :

SELECT * FORM Student AS S WHERE NOT EXIST

(SELECT cNo FROM Course WHERE dNo = "D01"

EXCEPT

SELECT cNo FROM Register WHERE sNo = S.sNo)

The number of rows returned by the above SQL query is _____________.

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
EXAM MAP
Medical
NEET