Home » Oracle » 1z0-117 » Which four types of column filtering may benefit from partition pruning when accessing tables via partitioned indexes?
Which four types of column filtering may benefit from partition pruning when accessing tables via partitioned indexes?
A. Equality operates on List-Partitioned Indexes
B. Not Equal operates on a Global Hash-Partitioned Indexes
C. Equality operates on System-Partitioned Tables
D. In-List operates on Range-Partitioned Indexes
E. Not Equal operates on a local Hash-Partitioned Indexes
F. Equality operates on Range-Partitioned Indexes
G. Equality operates on Hash-Partitioned Indexes
Correct Answer: ADFG
Explanation/Reference:
Oracle Database prunes partitions when you use range, LIKE, equality(A, F), and IN-list(D)predicates on the range or list partitioning columns, and when you use equality(G)and INlist predicates on the hash partitioning columns.
Reference:Oracle Database VLDB and Partitioning Guide11g,Information that can be Used for Partition Pruning
Download Printable PDF. VALID exam to help you PASS.
|
|