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、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 updates