IBM
C2090-312 · Question #19
Which ALTER TABLE statement will generate a new table space version?
The correct answer is B. ALTER TABLE ... ADD COLUMN COL2. See the full explanation below for the reasoning.
Question
Which ALTER TABLE statement will generate a new table space version?
Options
- AALTER TABLE ... ADD PARTITION ...
- BALTER TABLE ... ADD COLUMN COL2 ...
- CALTER TABLE ... DATA CAPTURE CHANGES ...
- DAltering an already existing VARCHAR column on the table to shorten its maximum length.
How the community answered
(68 responses)- A1% (1)
- B81% (55)
- C6% (4)
- D12% (8)
Community Discussion
No community discussion yet for this question.