Mainly indexes are 3 types: 1:-functional based index 2:-bit map index 3

How many different types of indexes we have in oracle?

Question Posted / vicky

Answer Posted / vicky

Mainly indexes are 3 types:
1:-functional based index
2:-bit map index
3:-b-tree index

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to create id with auto_increment on oracle?

1043

How is it different from a normal table?

1084

When do you get a .pll extension in oracle? Explain its importance

1100

How do I recompile a procedure in oracle?

1018

IS it possible to built the oracle database without setting the kernal parameters?

2397

Is oracle a relational database?

971

How many categories of data types?

1043

Â What are the oracle DML commands possible through an update strategy?

1106

How to recover a dropped table in oracle?

1096

What privilege is needed for a user to create tables in oracle?

994

How view is different from a table?

1090

How do we create privileges in oracle?

1103

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4572

How will you differentiate between varchar & varchar2?

1086

How does oracle handle read consistency?

1153