PrepAway - Latest Free Exam Questions & Answers

which statement(s) must be executed to add a new partition that already contains data for the first quarter of

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply