Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

Which statement describes the effect on an index, when the indexed column for the rows is
updated in the base table?

Which statement describes the effect on an index, when the indexed column for the rows is
updated in the base table?

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 logically deleted and a new leaf row is
inserted.



Leave a Reply 0

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