1Z0-515 · Question #41
Identify the benefit of using interval partitioning.
The correct answer is B. Automatic creation of new partitions based on the value of data being entered. 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…
Question
Identify the benefit of using interval partitioning.
Options
- AAutomatic creation of new partitions based on hash values
- BAutomatic creation of new partitions based on the value of data being entered
- CImproved performance compared to range partitions
- DAutomatic transfer of older partitions lower cost storage
How the community answered
(14 responses)- A7% (1)
- B71% (10)
- C14% (2)
- D7% (1)
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.
Topics
Community Discussion
No community discussion yet for this question.