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…
Sign in or unlock A2090-614 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.
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
Unlock A2090-614 to see the answer
You've previewed enough free A2090-614 questions. Unlock A2090-614 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.