nerdexam
Oracle

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.

New Features for Storage

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)
  • A
    5% (1)
  • B
    5% (1)
  • D
    91% (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.

Ainterval partitioning

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.

Blist partitioning

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.

Csystem partitioning

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.

Dhash partitioningCorrect

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.

Erange partitioningCorrect

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

#reference partitioning#parent table partitioning#hash partitioning#range partitioning

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice