How many different types of indexes we have in oracle?
Answer Posted / swapna
We have mainly two different indexes .
Implicit index and Explicit index.
Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.
| Is This Answer Correct ? | 179 Yes | 64 No |
Post New Answer View All Answers
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is oracle latest version?
How do I limit the number of oracle database connections generated by weblogic server?
Explain an exception and its types?
Explain about your project and its relation to the current job position you are applying to?
How to delete a user account in oracle?
What is Reduced List of Values?
How does Oracle guarantee data integrity of data changes?
How to filter out duplications in the returning rows using oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to commit the current transaction in oracle?
Compare and contrast between sql and sql server and explain its various functions?
How to write date and time interval literals in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is data type in oracle?