Which is NOT an available composite partition in Oracle Database 11g?
A.
range-list
B.
list-list
C.
list-range
D.
interval-hash
Explanation:
Extended Composite Partitioning
In previous releases of Oracle, composite partitioning was limited to Range-Hash and Range-List
partitioning. Oracle 11g Release 1 extends this to allow the following composite partitioning
schemes:
Range-Hash (available since 8i)
Range-List (available since 9i)
Range-Range
List-Range
List-Hash
List-List
Note: inverval-hash is a valid Interval partitioning.
Reference:
http://www.oracle-base.com/articles/11g/PartitioningEnhancements_11gR1.php
Question is obsolete e.g. all options availables since 11gR2.
Since 11gR2 composit interval partitioning extended to such options:
+ Interval
+ Interval-Range
+ Interval-List
+ Interval-Hash
Available [composite partitioning techniques] are range-hash, range-list, range-range, list-range, list-list, list-hash, and – new in Oracle Database 11g Release 2 – hash-hash.
The available techniques for an [interval partitioned] table are Interval, Interval-List, Interval-Hash, and Interval-Range.