Ordered Indices Multiple Choice Questions with Answers – PDF Download

MCQ 1: The number of types of ordered indices are:

1. 2
2. 3
3. 4
4. 5

MCQ 2: While insertion in a sparse index, we assume that the index stores an entry for each:

1. Index
2. Pointer
3. Position
4. Block

MCQ 3: Indices whose search key formation is different from the sequential order of the file, are known to be:

1. Non-clustering indices
2. Secondary indices
3. Primary indices
4. Both A and B

MCQ 4: Indices having two or more levels are called:

1. Multilevel indices
2. Clustered indices
3. Hierarchical indices
4. Densed indices

MCQ 5: The ordering of search-key values are named as:

1. Multigraphic ordering
2. Hashographic ordering
3. Lexicographic ordering
4. Conigraphic ordering