Consider a selection of the form σA<100(r), where r is a relation with 1000…

GATE · 2007 · IT

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 42 students.

Show answer

Correct answer: D

The worked solution is available to enrolled students.

Video solution available to enrolled students.

Explore the full course: Iocl Engineers Officers Grade A Paper 2