Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
Do you know how are Indexes Update?
Answer:
Index is a Database object . It can be accessed rows physical fast. when you move the table from different table spaces or same table spaces indexes will unusually status. So You compulsory rebuild the index. Rebuilding the index is very fast than drop and create the new indexes.
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain what is Rollback Segment? | Explain can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint? |