Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between implicit index and explicit
index?
- 2 Answers
- 24203 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 |
How to connect asp pages to oracle servers?
What is literal?
What are named parameters?
How to create a testing table in oracle?
How to get the Installed Oracle Version Information ?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What are various joins used while writing SUBQUERIES?
What are the different types of modules in oracle forms?
what is the scenario where you take the database to NoArchivelog mode?
What is a server parameter file in oracle?
Why is oracle so popular?
How to apply filtering criteria at group level in oracle?
Oracle General 
