IBM
C2090-312 · Question #159
You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement: ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5; What should be your next step?
The correct answer is C. REBUILD all of the indexes. See the full explanation below for the reasoning.
Question
You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement:
ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5; What should be your next step?
Options
- ACOPY the table space.
- BREORG the table space.
- CREBUILD all of the indexes.
- DDROP the segmented table space.
How the community answered
(45 responses)- A2% (1)
- B4% (2)
- C82% (37)
- D11% (5)
Community Discussion
No community discussion yet for this question.