Question

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 the file is small compared to the size of the memory.
(c) There can be many clustering indicies
(d) there can be at most one secondary index

Answer 1

it is preferable to use the dense index when the file is not sorted on the indexed field

Answer 2

a) is correct answer.