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

The relation schema, Person($\underline{\text{pid}}$, $city$), describes the city of residence for every person uniquely identified by $pid$. The following relational algebra operators are available: selection, projection, cross product, and rename.

To find the list of cities where at least 3 persons reside, using the above operators, the minimum number of cross product operations that must be used is

A

1

B

2

C

3

D

4

2
GATE CSE 2024 Set 2
Numerical
+2
-0.66

A functional dependency $F: X \to Y$ is termed as a useful functional dependency if and only if it satisfies all the following three conditions:

  • $X$ is not the empty set.
  • $Y$ is not the empty set.
  • Intersection of $X$ and $Y$ is the empty set.

For a relation $R$ with 4 attributes, the total number of possible useful functional dependencies is _________

Your input ____
3
GATE CSE 2024 Set 2
MCQ (Single Correct Answer)
+1
-0.33

The format of a single-precision floating-point number as per the IEEE 754 standard is:

Sign
(1 bit)
Exponent
(8 bits)
Mantissa
(23 bits)

Choose the largest floating-point number among the following options.

A

Sign

0

Exponent

0111 1111

Mantissa

1111 1111 1111 1111 1111 1111

B

Sign

0

Exponent

1111 1110

Mantissa

1111 1111 1111 1111 1111 1111

C

Sign

0

Exponent

1111 1111

Mantissa

1111 1111 1111 1111 1111 1111

D

Sign

0

Exponent

0111 1111

Mantissa

0000 0000 0000 0000 0000 0000

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

For a Boolean variable x, which of the following statements is/are FALSE?

A

x . 1 = x

B

x + 1 = x

C

x . x = 0

D

x + x̄ = 1

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