IBM
A2090-560 · Question #109
What is the limitation on join types with floating-point data types?
The correct answer is D. The system cannot perform a fast hash join on a floating point data type, but instead must. See the full explanation below for the reasoning.
Question
What is the limitation on join types with floating-point data types?
Options
- AThe system does not have a limitation on floating-point data types.
- BThe system cannot perform any type of join on floating-point data types.
- CThe system cannot perform a fast sort merge join on a floating point data type, but instead must
- DThe system cannot perform a fast hash join on a floating point data type, but instead must
How the community answered
(26 responses)- A8% (2)
- B15% (4)
- C4% (1)
- D73% (19)
Community Discussion
No community discussion yet for this question.