---

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

---

出自：Oracle认证

显示答案