Oracle
1Z0-043 · Question #7
In which two situations would you prefer to use a hash cluster? (Choose two.)
The correct answer is A. Evenly distributed key values are present in the table. E. The application frequently uses queries with an equality predicate on the cluster key. See the full explanation below for the reasoning.
Question
In which two situations would you prefer to use a hash cluster? (Choose two.)
Options
- AEvenly distributed key values are present in the table.
- BThe applications occasionally use queries joining tables.
- CThe data retrieval has to be in the order in which it was inserted.
- DThe applications frequently modify a cluster key value in a constantly growing table.
- EThe application frequently uses queries with an equality predicate on the cluster key.
How the community answered
(43 responses)- A81% (35)
- B2% (1)
- C5% (2)
- D12% (5)
Community Discussion
No community discussion yet for this question.