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 ?

  1. A.

    50

  2. B.

    100

  3. C.

    150

  4. D.

    200

Attempted by 163 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…