PrepAway - Latest Free Exam Questions & Answers

Which clause must be used with the CREATE TABLE statement to define this table?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
DISTRIBUTE BY HASH

B.
PARTITION BY RANGE

C.
ORGANIZE BY DIMENSIONS

D.
ORGANIZE BY KEY SEQUENCE

Explanation:


Leave a Reply