Home » Oracle » 1z0-591 » What kind of partition is being used?
A company’s Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?
A. Fact-based
B. Time-based
C. Mixed
D. Complex
Correct Answer: D
Explanation/Reference:
You have three sort of fragmentation:
Fact-based / Dimension-based fragmentation
Content-based / Value-based fragmentation
Level-based fragmentation / aggregate navigation
You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.
Incorrect answers:
A: Fact-based / Dimension-based fragmentation
The logical table sources have different columns.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
