nerdexam
IBM

C2090-312 · Question #160

Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified?

The correct answer is D. If the partitioning key is descending, DB2 allows the INSERT of a row with a null value for the key. See the full explanation below for the reasoning.

Question

Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified?

Options

  • AIf the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the
  • BIf the partitioning key is descending, DB2 prevents the INSERT of a row with a null value for the
  • CIf the partitioning key is ascending, DB2 allows the INSERT of a row with a null value for the key
  • DIf the partitioning key is descending, DB2 allows the INSERT of a row with a null value for the key

How the community answered

(53 responses)
  • A
    15% (8)
  • B
    4% (2)
  • C
    6% (3)
  • D
    75% (40)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice