As a result of performance analysis, you created an index on the prod_name column of the prod_det table, which contains about ten thousand rows. Later, you updated a product name in the table. How does this change affect the index?
A.
The index becomes invalid when you make any updates.
B.
The index will be updated automatically at commit.
C.
A leaf row in the index will be deleted and inserted.
D.
A leaf will be marked as invalid.
E.
An update in a leaf row takes place.