IBM
A2090-614 · Question #96
A2090-614 Question #96: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-614 to reveal the answer and full explanation for question #96. The question stem and answer options stay visible for context.
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?
Options
- ADISTRIBUTE BY HASH
- BPARTITION BY RANGE
- CORGANIZE BY DIMENSIONS
- DORGANIZE BY KEY SEQUENCE
Unlock A2090-614 to see the answer
You've previewed enough free A2090-614 questions. Unlock A2090-614 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.