IBM
A2090-614 · Question #98
A table named SALES was created as follows: Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first…
The correct answer is D. ALTER TABLE sales ATTACH PARTITION part_2013q1. See the full explanation below for the reasoning.
Question
A table named SALES was created as follows:
Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of 2013 to the SALES table and leave the table accessible?
Options
- AALTER TABLE sales ADD PARTITION part_2013q1
- BALTER TABLE sales ATTACH PARTITION part_2013q1
- CALTER TABLE sales ADD PARTITION part_2013q1
- DALTER TABLE sales ATTACH PARTITION part_2013q1
How the community answered
(46 responses)- A15% (7)
- B2% (1)
- C7% (3)
- D76% (35)
Community Discussion
No community discussion yet for this question.