052-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.

　　更新列会导致对其上的索引逻辑删除和插入。 PCTFREE 设置对索引没有影响，但创建时除外。即使索引块的空间少于PCTFREE 指定的空间，也可以向索引块添加新条目。