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

4
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 ____
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