How does this change to the table affect the index?

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the yearending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How
does this change to the table affect the index?

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the yearending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How
does this change to the table affect the index?

A.
An update in a leaf row takes place.

B.
The index becomes invalid after the update.

C.
The leaf block containing the row to be updated is marked as invalid.

D.
A row in the leaf block of the index for the key value is deleted and inserted.



Leave a Reply 0

Your email address will not be published. Required fields are marked *