Skip to content
Related Articles

Related Articles

Aptitude | GATE CS 1998 | Question 35

Improve Article
Save Article
  • Last Updated : 03 Nov, 2022
Improve Article
Save Article

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.
 


Quiz of this Question
Please comment below if you find anything wrong in the above post

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!