Oracle DB Optimization Question:
Download Questions PDF

Tell me what are the types of Indexes?

Answer:

Indexes can be clustered and non-clustered indexes.
Clustered index keeps all the records in the database in the order of clustered index key.
There can be only one clustered index per table.
Non-clustered indexes are stored as B-tree structure in their own storage separate from data storage in the table.

Download Oracle Database Optimization Interview Questions And Answers PDF

Previous QuestionNext Question
Do you have any idea what are indexes?Explain some disadvantages of the Indexes?