173.Which statement describes the effect on an index, when the indexed column for the rows is updated
in the base table?
A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.
答案:D
解析:参考171题,索引update的时候其实是二步,首先删除然后新增,而delete的时候并不是真正的删除,只是逻辑删除,做一个标记位而已
in the base table?
A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.
答案:D
解析:参考171题,索引update的时候其实是二步,首先删除然后新增,而delete的时候并不是真正的删除,只是逻辑删除,做一个标记位而已