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?

Question

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?

Accepted Answer

B. PARTITION BY RANGE

Answer

A. DISTRIBUTE BY HASH

Answer

C. ORGANIZE BY DIMENSIONS

Answer

D. ORGANIZE BY KEY SEQUENCE

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…

Question

Options

How the community answered

Community Discussion