OCP-1Z0-052-V8.02-173题

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.

Answer: D  

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12780775

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