Question

What is the function of the equi-width histogram?

(a) Adjusts boundaries of the ranges such that each range has the same number of values

(b) Divides range of values into equal sized ranges

(c) Divides the range of values into ideally sized ranges

(d) Does not divide the range of values.

I had been asked this question in an online interview.

My question is taken from Estimating Statistics of Expression Results topic in division Query Processing and Optimization of RDBMS

Answer 1

Correct answer is (b) Divides range of values into equal sized ranges

To explain I would say: The equi width histogram divides the range of values into equal sized ranges.