Identify the benefit of using interval partitioning.
A.
Automatic creation of new partitions based on hash values
B.
Automatic creation of new partitions based on the value of data being entered
C.
Improved performance compared to range partitions
D.
Automatic transfer of older partitions lower cost storage
Explanation:
Interval Partitioning was introduced in 11g, interval partitions are extensions to
range partitioning. These provide automation for equi-sized range partitions. Partitions are created
as metadata and only the start partition is made persistent. The additional segments are allocated
as the data arrives. The additional partitions and local indexes are automatically created.
Reference: Partitioning in Oracle 11g, Oracle FAQs
Think B
Interval partitioning is an enhancement to range partitioning in Oracle 11g and interval partitioning automatically creates time-based partit
Interval partitioning is an enhancement to range partitioning in Oracle 11g and interval partitioning automatically creates time-based partitions as new data is added.