1Z0-060 · Question #213
Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)
The correct answer is D. hash partitioning E. range partitioning. In Oracle 12c reference partitioning, the parent table must use range or hash partitioning; interval, list, and system partitioning are not supported as parent strategies in this context.
Question
Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)
Options
- Ainterval partitioning
- Blist partitioning
- Csystem partitioning
- Dhash partitioning
- Erange partitioning
How the community answered
(22 responses)- A5% (1)
- B5% (1)
- D91% (20)
Why each option
In Oracle 12c reference partitioning, the parent table must use range or hash partitioning; interval, list, and system partitioning are not supported as parent strategies in this context.
Interval partitioning is not a supported partitioning method for the parent table when reference partitioning is used in Oracle 12c; the auto-extensible nature of interval partitions is incompatible with the reference partitioning mechanism.
List partitioning is not supported as a parent table partitioning strategy for reference partitioning in Oracle 12c; only range and hash are recognized parent strategies in this release.
System partitioning delegates partition management entirely to the application and has no partition key or constraint - making it structurally incompatible with the foreign-key-based inheritance required by reference partitioning.
Hash partitioning is a supported strategy for the parent table in a reference partitioning relationship. The child table inherits the same hash bucket count and distribution from the parent via the enforced foreign key, ensuring co-location of related rows.
Range partitioning is a supported strategy for the parent table in reference partitioning. The child table automatically inherits the parent's range boundaries through the foreign key constraint, allowing partition pruning and partition-wise joins without replicating the partition key in the child.
Concept tested: Oracle reference partitioning supported parent partition strategies
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/vldbg/partition-concepts.html#GUID-F0A7878F-FD93-44CE-A034-77D71DA9B658
Topics
Community Discussion
No community discussion yet for this question.