INDEX Are Of 4 Types 1.NORMAL OR SIMPLE OR B-TREE Index 2.BITMAP INDEX 3

How many different types of indexes we have in oracle?

Question Posted / debasis mohanty

Answer Posted / debasis mohanty

INDEX Are Of 4 Types
1.NORMAL OR SIMPLE OR B-TREE Index
2.BITMAP INDEX
3.COMPOSITE INDEX
4.FUNCTION BASED INDEX

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

State and explain the different types of data models?

996

What is the difference between a hot backup and a cold backup in oracle?

1079

Why does for update in oracle 8 cause an ora-01002 error?

1051

interview questions with answer for cts

2638

What is tns service name?

1180

How do we represent comments in oracle?

1098

Why cursor variables are easier to use than cursors?

1142

What are the data types in oracle?

1099

Explain implicit cursor.

1075

Can we create trigger on materialized view in oracle?

1045

What do you mean by group by clause?

1094

What is a data dictionary and how can it be created?

1240

Where do we use decode and case statements?

1063

What is connection pool in oracle?

1039

How to fetch the row which has the max value for a column?

1047