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

175. What can you achieve by implementing reverse key index?

A.Reverse the bytes of each column indexed including the row ID.

B.Store a bitmap for each key value instead of a list of row IDs in the leaf node.

C.Prevent contention on the highest leaf block when using sequences to generate keys.

D.Remove repeated key values from the index to fit more index entries in a given amount of disk space.

Answer: C  

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e40540/indexiot.htm#CNCPT1181

Reversing the key solves the problem of contention for leaf blocks in the right side of a B-tree index