Single Level Order Indexes Multiple Choice Questions (MCQ) PDF Download

MCQ 1: The index which has an entry for some of the key value is classified as

1. linear index
2. dense index
3. non dense index
4. cluster index

MCQ 2: The primary indexes, secondary indexes and cluster indexes are all types of

1. ordered indexes
2. unordered indexes
3. linear indexes
4. relative search indexes

MCQ 3: The example of non dense index is

1. ternary index
2. secondary index
3. primary index
4. clustering index

MCQ 4: In the data file, the first record of any of the block is called

1. anchor record
2. dense record
3. non dense record
4. none of above

MCQ 5: The first field in the primary index having same data type as in the ordering field is considered as

1. indexed key
2. ternary key
3. secondary key
4. primary key