IBM
C2090-312 · Question #145
Which table characteristic is a good attribute for the exploitation of hash access?
The correct answer is C. The size of individual rows in the table vary greatly. See the full explanation below for the reasoning.
Question
Which table characteristic is a good attribute for the exploitation of hash access?
Options
- AAt least 20 rows fit on a data page.
- BDB2 uses range scans to access rows in the table.
- CThe size of individual rows in the table vary greatly.
- DDB2 uses sequential lookups to access data in the table.
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C86% (24)
- D4% (1)
Community Discussion
No community discussion yet for this question.