nerdexam
IBM

A2090-560 · Question #51

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

(19 responses)
  • A
    5% (1)
  • B
    79% (15)
  • C
    5% (1)
  • D
    11% (2)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice