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?
A.
ALTER TABLE sales ADD PARTITION part_2013q1
STARTING (’01/01/2013′) ENDING (’03/31/2013′) IN ts5;
B.
ALTER TABLE sales ATTACH PARTITION part_2013q1
STARTING (’01/01/2013′) ENDING (’03/31/2013′)
FROM TABLE q12013_sales;
C.
ALTER TABLE sales ADD PARTITION part_2013q1
STARTING (’01/01/2013′) ENDING (’03/31/2013′) IN ts5;
SET INTEGRITY FOR sales IMMEDIATE CHECKED;
D.
ALTER TABLE sales ATTACH PARTITION part_2013q1
STARTING (’01/01/2013′) ENDING (’03/31/2013′)
FROM TABLE q12013_sales;
SET INTEGRITY FOR sales IMMEDIATE CHECKED;
Explanation: