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)

The index field associated with the values 1, 3, 2, 5 and 4 is the Occupation field because after sorting the Occupational field lexiographically will give the sequence 1,3,2,5,4.

Quiz of this Question

My Personal Notes arrow_drop_up

Improved By : AmanSrivastava1