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

参考答案和解析
正确答案: D
解析: 暂无解析
更多“单选题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”相关问题