單項(xiàng)選擇題

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

微信掃碼免費(fèi)搜題