1. The number of levels in multi-level index depends on

a.the number of records

b.the size of index block

c.the size of index entries

d. all of a., b., and c.

2. ___________ is an index specified on the non-key non-ordering field of an ordered file of records.

a. Clustering index

b. Secondary index

c. Primary index

d. Multi-level index

3. ______________________ has the least number of block accesses to search and retrieve a record (Assume the number of records is very big).

a. Primary index

b. Secondary index

c. Cluster index

d. B-tree/B+-Tree