Question

An Oracle server index ___________________.

• A. Is a schema object
• B. Is used to speed up the retrieval of rows by using a pointer
• C. Is independent of the table it indexes
• D. All of the above

Answer 1

The correct option is D All of the above

An Oracle server index:-

An Oracle server index is a schema object that can speed up the retrieval of rows by using a pointer. Indexes can be created explicitly or automatically. If we do not have an index on the column, then a full table scan occurs.

Indexesare logically and physically independent of the data in the associated table.

An index is a copy of selected columns of data from a table that can be searched very efficiently that also includes a low-level disk block address or direct link to the complete row of data it was copied from.