Topic : Index

Index is a Space demanding Object ?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss

What are the different types of indexes available in Oracle?


Answer :

Oracle provides several Indexing schemas
B-tree index - Retrieves a small amount of information from a large table.
Global and Local index - Relates to partitioned tables and indexes.
Reverse Key Index - It Is most useful for oracle real application clusters applications.
Domain Index - Refers to an application
Hash cluster Index - Refers to the index that is defined specifically for a hash cluster.

Show Answer Discuss

Give the reasoning behind using an index


Answer :

Faster access to data blocks in a table.

Show Answer Discuss

What type of index should you use on a fact table?


Answer :

A Bitmap index.

Show Answer Discuss

How can you rebuild an index?


Answer :

ALTER INDEX REBUILD;

Show Answer Discuss