nerdexam
IBM

P2090-050 · Question #57

Which statement regarding temporary tables is true?

The correct answer is B. They may include a DISTRIBUTE ON clause. See the full explanation below for the reasoning.

Question

Which statement regarding temporary tables is true?

Options

  • AThey are limited to 1 terabyte in size.
  • BThey may include a DISTRIBUTE ON clause.
  • CThey are limited to 16 per user per database.
  • DThey will be included in any nzbackup of the database.

How the community answered

(43 responses)
  • A
    7% (3)
  • B
    74% (32)
  • C
    2% (1)
  • D
    16% (7)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice