Test: Indexing - 2 - Computer Science Engineering (CSE) MCQ

There is no difference in the number of records in the index and main tables when using Dense Index.

Sparse index records appear only for a few items in the data file.

An index that points to the records in a gap in the main table rather than each record in the main table is a sparse index.

The index can be built on columns other than primary keys, which are not guaranteed to be unique.

Creating indices for these groups of records is done after groups of records which have similar characteristics are grouped together.

Whenever the size of the table increases, so does the size of the mapping.

Based on the address mapped to the secondary memory, that memory searches for the data.

When the mapping size grows, the sparse index is inefficient.

In the secondary index method, the large ranges of the columns are selected to begin with so that the first level of mapping becomes small.

Both the second level mapping and actual data are stored on the hard disk (secondary memory).