We have mainly two different indexes . Implicit index and Explicit index

How many different types of indexes we have in oracle?

Question Posted / nagaraju

24 Answers
191782 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / nagaraju

We have mainly two different indexes .

Implicit index and Explicit index.

Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different editions of oracle?

1060

Explain a segment?

1033

What is oracle host variable?

994

How to get the Installed Oracle Version Information ?

1086

What is a Garbage Collection? and what is full recursive Garbage collection?

2861

How to login to the server without an instance?

1115

How to define a data field as not null?

1071

How to use fetch statement in a loop?

983

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

927

What are the common oracle dba tasks?

1079

How do I know if oracle client is installed on windows?

964

Explain what are the different type of segments?

920

please explain.. DB architecture ...

1976

What is PL/SQL ?

1924

What is a tns file?

948