What is the difference between implicit index and explicit
index?
Answers were Sorted based on User's Feedback
Answer / daid kuamr
Implicite index is created by oracle Internally
ex: when we make a primary key in a Column then implicit
Index created which is Clustered Type index(Default)
while Explicite index created by "Create Index Command'
User
Is This Answer Correct ? | 26 Yes | 5 No |
what is view?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is an oracle database?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to use in conditions in oracle?
What is sharded cluster?
Explain the use of log option in exp command.
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to use fetch statement in a loop?