You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）

A leaf will be marked as invalid.
B. An update in a leaf row takes place.
C. The index will be updated automatically at commit.
D. A leaf row in the index will be deleted and inserted.
E. The index becomes invalid when you make any update