Oracle 11G OCP 1Z0-053 261

（261）In which cases is reference partitioning effective in enhancing performance?

A. It is effective only in partition pruning.

B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

答案：（D）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1268127/，如需轉載，請註明出處，否則將追究法律責任。