Mainly Two type of Index in Oracle. 1:-> Logical 2:-> Physical 1

How many different types of indexes we have in oracle?

Question Posted / rajesh

Answer Posted / rajesh

Mainly Two type of Index in Oracle.
1:-> Logical
2:-> Physical

1:-> Unique,Non Unique,Function
2:-> B-Tree & Bitmap

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to execute a stored program unit?

1015

What language does oracle use?

1057

How to define an oracle sub procedure?

1067

How to select all columns of all rows from a table in oracle?

1001

Use of an integrity constraint is better to validate data. Explain

987

How to start an oracle instance?

960

How to write numeric literals in oracle?

1133

Explain the use of full option in exp command.

1064

How to assign values to variables?

1053

Explain a segment?

1033

How to concatenate two text values in oracle?

1058

What do you mean by merge in oracle?

944

Explain the use of indexes option in imp command.

1102

why dont we assign not null constraint as table level constraint.

2690

Why do we need oracle client?

895