Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 191959 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / ananthram
Just and Addition to the above discussion.
I cant agree completely with answer #3 when it says
"This index is not Unique index "
Because Oracle makes sure that the uniqueness is maintained
in case of Primary and unique key by imposing UNIQUE INDEX
on it.
So I find it difficult when someone says that the implicit
indexes created by oracle while the creation of PK and UK
are not UNIQUE indexes.
| Is This Answer Correct ? | 32 Yes | 9 No |
Post New Answer View All Answers
What is oracle used for?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to pass parameters to procedures in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What are operators in oracle?
In oracle there is column command, how will you explain that?
What are the roles of dba?
What is a initialization parameter file in oracle?
what is a Nested Loop join?
What is the best way to do multi-row insert in oracle?
What are the tools for Oracle ?
How to open a cursor variable?
Explain integrity constraints?
What are a collation and state the different types of collation sensitivity?
How to get execution path reports on query statements?
