Consider a selection of the form σA≤100(r), where r is a relation with 1000…
PYQ GATE 2007
Consider a selection of the form σA≤100(r), where r is a relation with 1000 tuples. Assume that the attribute values for A among the tuples are uniformly distributed in the interval [0, 500]. Which one of the following options is the best estimate of the number of tuples returned by the given selection query ?
- A.
50
- B.
100
- C.
150
- D.
200
Attempted by 163 students.
Sign up free to check your answer
Sign up freeLoading lesson…

