What is the difference between implicit index and explicit
index?
- 2 Answers
- 23428 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 |
Who developed oracle & when?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
How to invoke the data pump import utility?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
find out first highest salary?
10 Answers Verinon Technology Solutions,
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What is oracle analytical function?
How to define an oracle sub procedure?
What is the maximum number of CHECK constraints that can be defined on a column ?
Explain about functional dependency and its relation with table design?
How do we create privileges in oracle?
Explain the difference between sap and oracle?
Oracle General 
