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

Which of the following statements about a relation $R$ in first normal form (1NF) is/are TRUE?

A

$R$ can have a multi-attribute key

B

$R$ cannot have a foreign key

C

$R$ cannot have a composite attribute

D

$R$ cannot have more than one candidate key

2
GATE CSE 2024 Set 1
Numerical
+1
-0.33

Consider the following two relations, R(A, B) and S(A, C):

R
AB
1020
2030
3040
3050
5095
S
AC
1090
3045
4080

The total number of tuples obtained by evaluating the following expression

$$ \sigma_{B < C}(R \bowtie_{R.A = S.A} S) $$

is _________

Your input ____
3
GATE CSE 2024 Set 1
MCQ (More than One Correct Answer)
+2
-0.66

The symbol → indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?

A

(X, Y) → (Z, W) implies X → (Z, W)

B

(X, Y) → (Z, W) implies (X, Y) → Z

C

((X, Y) → Z and W → Y) implies (X, W) → Z

D

(X → Y and Y → Z) implies X → Z

4
GATE CSE 2024 Set 1
MCQ (More than One Correct Answer)
+2
-0.66

Consider the following read-write schedule $S$ over three transactions $T_{1}$, $T_{2}$, and $T_{3}$, where the subscripts in the schedule indicate transaction IDs:

$S: r_{1}(z); w_{1}(z); r_{2}(x); r_{3}(y); w_{3}(y); r_{2}(y); w_{2}(x); w_{2}(y);$

Which of the following transaction schedules is/are conflict equivalent to $S$?

A

$T_{1}T_{2}T_{3}$

B

$T_{1}T_{3}T_{2}$

C

$T_{3}T_{2}T_{1}$

D

$T_{3}T_{1}T_{2}$

EXAM MAP
Medical
NEETAIIMS
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
Civil Services
UPSC Civil Service
Defence
NDA
Staff Selection Commission
SSC CGL Tier I
CBSE
Class 12