Which four types of column filtering may benefit from partition pruning when accessing tables via partitioned indexes?

The correct answer is A. Equality operates on List-Partitioned Indexes D. In-List operates on Range-Partitioned Indexes F. Equality operates on Range-Partitioned Indexes G. Equality operates on Hash-Partitioned Indexes. 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 IN-list predicates on the hash partitioning columns. Partition Pruning

Using Indexes and Materialized Views for Tuning

Question

Options

AEquality operates on List-Partitioned Indexes
BNot Equal operates on a Global Hash-Partitioned Indexes
CEquality operates on System-Partitioned Tables
DIn-List operates on Range-Partitioned Indexes
ENot Equal operates on a local Hash-Partitioned Indexes
FEquality operates on Range-Partitioned Indexes
GEquality operates on Hash-Partitioned Indexes

How the community answered

(26 responses)

A
77% (20)
B
4% (1)
C
12% (3)
E
8% (2)

Explanation

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 IN-list predicates on the hash partitioning columns. Partition Pruning

Topics

#partition pruning#partitioned indexes#range partition#hash partition

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice