A DBA wants to create a table named SALES that has the following characteristics:
Data for the first half of the year will reside in table space TBSP1; the index for this data will
reside in table space TBSP21.
Data for the second half of the year will reside in table space TBSP2; the index for this data will
reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?
A.
DISTRIBUTE BY HASH
B.
PARTITION BY RANGE
C.
ORGANIZE BY DIMENSIONS
D.
ORGANIZE BY KEY SEQUENCE
Explanation: