1
GATE CSE 2026 Set 2
MCQ (Single Correct Answer)
+2
-0

An index in a DBMS is said to be dense if an index entry appears for every searchkey value in the indexed file. Otherwise it is called a sparse index. Consider the following two statements.

S1: A hash index must be a dense index

S2: A $\mathrm{B}^{+}$tree index can be a sparse index

Which one of the following options is correct?

A

Both S 1 and S 2 are true

B

Both S 1 and S 2 are false

C

S 1 is true and S 2 is false

D

S1 is false and S2 is true

2
GATE CSE 2026 Set 2
MCQ (Single Correct Answer)
+1
-0

Which one of the following options is not a property of Boolean Algebra?

Note: + is OR operation, • is AND operation, and ' is NOT operation

A

$a+b=b+a$

B

$a \cdot a^{\prime}=1$

C

$a+a^{\prime}=1$

D

$a \times b=b \cdot a$

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

In a system, numbers are represented using 4-bit two's complement form. Consider four numbers $N 1=1011, N 2=1101, N 3=1010$ and $N 4=1001$ in the system. Which of the following operations will result in arithmetic overflow?

A

$\mathrm{N} 1+\mathrm{N} 2$

B

$\mathrm{N} 2+\mathrm{N} 3$

C

$\mathrm{N} 3-\mathrm{N} 4$

D

$N 1+N 4$

4
GATE CSE 2026 Set 2
Numerical
+1
-0

The 32-bit IEEE 754 single precision representation of a number is 0xC2710000. The number in decimal representation is $\_\_\_\_$ . (rounded off to two decimal places)

Your input ____