Answer Posted / orawhiz
Indexes are automatically maintained and used by ORACLE.
Changes to table data are automatically incorporated into
all relevant indexes.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to export data to a csv file?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is concurrency in oracle?
Why do you use stored procedures and state some of its disadvantages?
What the is the diff between local index and global index. give some example.
What is coalesce function?
What happens if variable names collide with table/column names?
What is oracle data type?
How to rename an index in oracle?
What is an oracle data file?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How will you write a query to get a 5th rank student from a table student_report?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
how to clone 9i Database on to 10g Database.
How to create a temporary table in oracle?