Aptitude | GATE CS 1998 | Question 35

There are 5 records in a database.

Name     Age    Occupation    Category
Rama     27       CON            A
Abdul    22       ENG            A
Jeniffer 28       DOC            B
Maya     32       SER            D
Dev      24       MUS            C

There is an index file associated with this and it contain the values 1, 3, 2, 5 and 4. Which one of the fields is the index built form?
(A) Age
(B) Name
(C) Occupation
(D) Category

Answer: (C)

Explanation: The index field associated with the values 1, 3, 2, 5 and 4 is the Occupation field because after sorting the Occupational field lexicographically will give the sequence 1, 3, 2, 5, 4.
So, option (C) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up