IBM
A2090-614 · Question #84
A DBA wants to create a table named SALES that has the following characteristics: -effective data clustering and management of space utilization -rows in the table should be clustered based on when…
The correct answer is B. ORGANIZE BY INSERT TIME. See the full explanation below for the reasoning.
Question
A DBA wants to create a table named SALES that has the following characteristics:
-effective data clustering and management of space utilization -rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
Options
- AORGANIZE BY DIMENSIONS
- BORGANIZE BY INSERT TIME
- CORGANIZE BY TIME PERIOD
- DORGANIZE BY KEY SEQUENCE
How the community answered
(27 responses)- A7% (2)
- B78% (21)
- C4% (1)
- D11% (3)
Community Discussion
No community discussion yet for this question.