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

Answer Posted / nishi

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)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a partition in oracle?

521


How many anonymous blocks can be defined?

563


How to update values in a table in oracle?

552


How to select some columns from a table in oracle?

516


What is a synonym? What are its various types?

602






Compare and contrast between sql and sql server and explain its various functions?

501


What is oracle and what are its different editions?

548


How can we find out the current date and time in oracle?

623


How to export several tables together?

538


What are the logical operations?

651


How to rename an existing table?

583


What are the system predefined user roles?

561


What is a procedure in oracle?

591


How to rename an index in oracle?

590


Explain what are the different type of segments?

552