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

Let S be the specification : "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following ER diagrams CORRECTLY represents S?

GATE CSE 2024 Set 1 Database Management System - Er Diagrams Question 2 English 1 GATE CSE 2024 Set 1 Database Management System - Er Diagrams Question 2 English 2

A

(i)

B

(ii)

C

(iii)

D

(iv)

2
GATE CSE 2024 Set 1
MCQ (Single Correct Answer)
+1
-0.33

In a B+ tree, the requirement of at least half-full (50%) node occupancy is relaxed for which one of the following cases?

A

Only the root node

B

All leaf nodes

C

All internal nodes

D

Only the leftmost leaf node

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

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

4
GATE CSE 2024 Set 1
Numerical
+1
-0

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 ____
EXAM MAP