Answer Posted / nishi
Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens to indexes if you drop a table?
Explain the types of exception?
What are a collation and state the different types of collation sensitivity?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to run queries on external tables?
What is null value in oracle?
How to invoke the data pump import utility?
How to invoke the data pump export utility?
How to delete a user account in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the ways tablespaces can be managed and how do they differ?
What is ASM (Automatic Storage Management) in Oracle?
Is the After report trigger fired if the report execution fails ?
How to update values on multiple rows in oracle?
What is meant by a deadlock situation?