Question

What do you call an index if the index record contains the search-key value and a pointer to the first data record with that search-key value?

Select one:

a. A loose primary index

b. A dense primary index

c. A compact primary index

d. A sparse primary index

e. A crowded primary index

Answer 1

Answer: b)A dense primary index

Explanation: Dense primary key is defined as all the search key belonging to the database has a corresponding index record. The record searching becomes easier and quick with this technique .The drawback of this index is requires large space for storage of records. Index persist of the key value and pointer for the record.

Other options are incorrect because loose index works for only some fraction of keys and compact primary index contains the record in compact column manner. Sparse primary index contains record of indexed area and crowded index is over the crowd ratio index .Thus, the correct option is option(b).