Indentify the true statement about REF partitions.
A.
REF partitions have no impact on partition-wise joins.
B.
Changes to partitioning in the parent table are automatically reflected in the child table.
C.
Changes in the data in a parent table are reflected in a child table.
D.
REF partitions can save storage space in the parent table.
Explanation:
Reference partitioning is a partitioning method introduced in Oracle 11g. Using
reference partitioning, a child table can inherit the partitioning characteristics from a parent table.
New Question 71: Can you please add it?
How does partitioning help to INCREASE AVAILABILITY?
A. Partitioning provides RESILIENT FAILOVER
B. Helps MAINTENANCE by allowing for MAINTENANCE on partitions one by one
C. Decrease LIKELIHOOD of individual partitions BECOME UNAVAILABLE
D. Adds INTEGRITY CHECKS as part of the partitioning
Don’t take me up on the exact wording, I just focused to memorize the bold buzzwords and the order of the choices. BTW: I voted for answer B
B
i think, A is correct, because use of ref partitioning automatically use Wise-join
and provide use parallelism to attack query , inclusive in several instances In Oracle RAC.
it means A and B
Reference partitioning implicitly enables full partition-wise joins.
Answer is B