Question

What is the use of an index?

(a) Retrieve data more quickly and efficiently

(b) Related data requires much less I/O overhead if accessed simultaneously

(c) Simplify the user’s perception of data access

(d) All of the Mentioned

I got this question in unit test.

This intriguing question comes from Oracle Database 11g Architecture topic in chapter Oracle Database 11g Architecture Options of Oracle

Answer 1

The correct answer is (a) Retrieve data more quickly and efficiently

To explain I would say: Index is used for to perform the quick operation on the data.