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

Describe varray?

595

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

548

What are the advantages of oracle?

555

Explain an index?

658

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

577

How to retrieve values from data fields in record variables?

573

How to test null values?

680

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1676

How do I recompile a procedure in oracle?

527

What is clustered table in Oracle?

645

interview questions with answer for cts

2090

what is port in oracle? how is it related to database application.

1443

What happens to the indexes if a table is recovered?

579

How to load data through external tables?

585

How to define a record variable to store a table row?

579