Question - What is an Index ? How it is implemented in Oracle Database ?
Answer -
An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)