Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192749 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 are the various oracle database objects?
How to store pictures on to the database?
How to define a record variable to store a table row?
How to upsert (update or insert into a table)?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is a table index?
Explain constraining triggers.
What is the max number of columns in an oracle table?
What are nested tables?
State and explain about oracle instance?
How to use like conditions in oracle?
How to convert numbers to characters in oracle?
What do you mean by merge in oracle and how can you merge two tables?
How to drop an existing table in oracle?
What is program global area (pga) in oracle?
