Question

Question 8 Choose the correct option/s about the indexing a) It is preferable to use a dense index when the file is not sorted on the indexed field. b) Dense index is preferred over sparse index when file is small compared to the size of memory. c) There can be many clustering indices. d) There can be at most one secondary index.

Answer 1

option a i am right

Answer 2

a option is closer to the given question