Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?
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 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 _________
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.