A partitioned table named SALES was created as follows:
Which statement about the PARTS_IDX index is true?
A. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP3.
B. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.
C. The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.
D. The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third in TBSP2.
|
Download Printable PDF. VALID exam to help you PASS. |
 |