IBM
C2090-320 · Question #53
Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)
The correct answer is B. ENDING AT clause on a CREATE INDEX statement for the table E. A LOB column specified as a column of the partitioning key. See the full explanation below for the reasoning.
Question
Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)
Options
- AMAXPARTITIONS
- BENDING AT clause on a CREATE INDEX statement for the table
- CMEMBER CLUSTER
- DENDING AT clause on the CREATE TABLE statement
- EA LOB column specified as a column of the partitioning key
How the community answered
(27 responses)- A7% (2)
- B74% (20)
- C4% (1)
- D15% (4)
Community Discussion
No community discussion yet for this question.