Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between implicit index and explicit
index?
- 2 Answers
- 24010 Views
- TCS, I also Faced
- E-Mail Answers
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 the difference between rollback & commit? can a foreign key has null value?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is tns entry?
What WHERE CURRENT OF clause does in a cursor?
What is an UTL_FILE.What are different procedures and functions associated with it?
What is the use of Control File ?
What is a server parameter file in oracle?
Why do you create or replace procedures rather that drop and recreate.
What is the difference between formal parameters and actual parameters?
Explain the difference between a procedure and a function?
Oracle General 
