1Z0-515 · Question #40
You want partitions to be automatically created when data that does not fit into current date range loaded. Which type of partitioning would you implement?
The correct answer is D. Interval. 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
You want partitions to be automatically created when data that does not fit into current date range loaded. Which type of partitioning would you implement?
Options
- AHash
- BList
- CInvisible
- DInterval
How the community answered
(53 responses)- A17% (9)
- B4% (2)
- C8% (4)
- D72% (38)
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. Note: Partitioning is one of the most sought after options for data warehousing. Almost all Oracle data warehouses use partitioning to improve the performance of queries and also to ease the day-to-day maintenance complexities. Starting with 11G, more partitioning options have been provided and these should reduce the burden of the DBA to a great extent.
Topics
Community Discussion
No community discussion yet for this question.