Question

Which of the following is an issue that needs to be considered while choosing an indexing technique?

(a) Frequency of insertion and deletion

(b) Data types of the data

(c) Number of items in the relation

(d) None of the mentioned

The question was posed to me at a job interview.

This interesting question is from Dynamic Hashing topic in section Indexing and Hashing of RDBMS

Answer 1

The correct answer is (a) Frequency of insertion and deletion

For explanation I would say: The frequency of insertion and deletion has to be taken into consideration while choosing an indexing technique. The frequency of insertion and deletion determines the hash index.