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)- A15% (8)
- B4% (2)
- C6% (3)
- D75% (40)
Community Discussion
No community discussion yet for this question.