Question

Overflow resolution is performed when,

(a) A hash index overflow is detected

(b) Extra hash indices are to be added

(c) When the number of partitions are to be increased

(d) None of the mentioned

I had been asked this question during an internship interview.

My question is from Join and Other Operations in division Query Processing and Optimization of RDBMS

Answer 1

Correct option is (a) A hash index overflow is detected

The explanation: Hash table overflows can be handled by either overflow resolution or overflow avoidance. Overflow resolution is performed when a hash index overflow is detected.