nerdexam
IBM

P2090-050 · Question #100

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

(29 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    10% (3)
  • D
    83% (24)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice