单选题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 tab
题目
单选题
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