Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 193461 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / sudev kuma rmishra
two types
A.implicit B.explicit
A.implicit index
automatically created when we mention primary key or unique key
B.explicit index
these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is tns name?
Why do you create or replace procedures rather that drop and recreate.
How to enter a new row into a table interactively?
What is not equal to in oracle?
Explain how are indexes update?
what is the difference between functional dependecy and multilevel dependency?
How to connect asp pages to oracle servers?
What is the disadvantage of User defind function?
What is transport network substrate (tns) in oracle?
What are the oracle differences between nvl and coalesce
Explain an integrity constrains?
What would you do with an in-doubt distributed transaction?
What is the database name in oracle?
What is a oracle database?
What is a snapshot in oracle database?
