IBM
C2090-312 · Question #71
Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?
The correct answer is B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE >. See the full explanation below for the reasoning.
Question
Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?
Options
- AIssue ALTER TABLESPACE with a valid SEGSIZE > 0
- BMake the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE >
- CDrop the partitioning index, ALTER the table definition by adding partition ranges to the existing
- DDrop the partitioning index, ALTER the table definition by adding partition ranges to the existing
How the community answered
(50 responses)- A12% (6)
- B76% (38)
- C4% (2)
- D8% (4)
Community Discussion
No community discussion yet for this question.