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?
A.
Hash
B.
List
C.
Invisible
D.
Interval
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 dayto-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.
Reference: Partitioning in Oracle 11g, Oracle FAQs
D