Multiple choice

These are five records in a data base:

     
Name Age Occupation Category
Neha 23 CON A
Dhruti 24 ENG B
Sonika 25 DOC C
Poonam 26 SER D

There is an index file associated with this and it contains the values: 1, 3, 2, 4. Which of the following fields is the index built form?

  1. Age

  2. Name

  3. Occupation

  4. Category

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Sorting records by Occupation alphabetically: CON(1), DOC(3), ENG(2), SER(4) gives the index order [1,3,2,4]. This matches the given index file values.

Keep practicing — related questions