Database Administrator (DBA) Question:

What is an Index? How it is implemented in Oracle Database?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

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 command (Ver 7.0)


Previous QuestionNext Question
What is database clusters?What is a Database instance?