1
GATE CSE 2022
MCQ (Single Correct Answer)
+1
-0.33

In a relational data model, which one of the following statements is TRUE?

A
A relation with only two attributes is always in BCNF.
B
If all attributes of a relation are prime attributes, then the relation is in BCNF.
C
Every relation has at least one non-prime attribute.
D
BCNF decompositions preserve functional dependencies.
2
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))
3
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 _________.

Your input ____
4
GATE CSE 2022
MCQ (Single Correct Answer)
+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
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12