If the following SQL statement is executed:
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING ‘1/1/2007′ ENDING ’12/31/2007’
EVERY 3 MONTHS)
Which of the following statements is true?
A.
Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES
table must be done at the table level; not at the partition level
B.
Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and
DETACH PARTITION clauses of the ALTER TABLE statement
C.
If an index is created for the SALES table, its data must be stored in table space TBSP0
D.
When resolving queries against the SALES table, each partition used is scanned
asynchronously and the results of each partition scan are merged to produce the result data set
returned
ATTACH PARTITION clause makes data roll-in very easy. It takes an existing table (source table) and attaches it to the target table as a new data partition.
Table partitioning allows for the efficient roll-in and roll-out of table data. This efficiency is achieved by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement.
0
0