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

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

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.

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

- Dense Index is a type of primary index where there is an index entry for every search key value in the data file.
- Sparse Index is another type of primary index where only some of the search key values have an index entry.
- Both A and B are types of primary indexes used in database systems to efficiently locate records.

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

Since primary keys are sorted, search operations are quite efficient because of their sorted order.

It is known as primary indexing if the index is created based on the table's primary key.

Searches are usually made faster by sorting the indices.

There are 2 types of primary index.

There are 4 indexing methods.