IBM
A2090-614 · Question #98
A2090-614 Question #98: Real Exam Question with Answer & Explanation
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
Community Discussion
No community discussion yet for this question.