How many different types of indexes we have in oracle?
Answer Posted / siva
There are four reguler types of Indexes in oracle
1.Normal index
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.
The custom and recommended types are of 2 types
Implicit index and Explicit index.
Is This Answer Correct ? | 39 Yes | 8 No |
Post New Answer View All Answers
How to rename an existing table?
Explain the use of indexes option in exp command.
What is meant by joins? List out the types of joins.
Is oracle an operator?
How to connect to oracle using service name instead of sid?
How to resolve the ORA-39133 error in Oracle?
Why do we use bulk collect in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Explain oracle insert into command?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to test null values?
What is merge statement used for?
What is the meaning of recursive hints in oracle?
How to declare a local variable?
What are data pump export and import modes?