Upgrade to Oracle Database 12c — Question 10

Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)

Answer options

• A. interval partitioning
• B. list partitioning
• C. system partitioning
• D. hash partitioning
• E. range partitioning

Correct answer: D, E

Explanation

Hash partitioning (D) and range partitioning (E) are both compatible methods for a parent table in reference partitioning, as they efficiently distribute data across partitions. Interval partitioning (A), list partitioning (B), and system partitioning (C) do not align with the requirements for reference partitioning in this context.