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