How are the index updates?



How are the index updates?..

Answer / 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

More Oracle General Interview Questions

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,


what is difference between where clause and having clause?

13 Answers  


What is an Index ?

2 Answers  


In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,


What is oracle database client?

1 Answers  


wirte the syntax of update query?

3 Answers   IBM,


Can we insert data in view oracle?

1 Answers  


Why we choose emp number as primarykey?

4 Answers  


How to upsert (update or insert into a table)?

1 Answers  


Explain the difference between a procedure and a function?

1 Answers  


What is the difference between truncate & delete command?

1 Answers  


what is shell?

2 Answers   Microsoft,


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)