Câu 39: C2090-611: DB2 10.1 DBA for Linux UNIX and Windows

A partitioned table named SALES was created as follows: Which statement about the PARTS_IDX index is true?

1. A. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP3.
2. B. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.
3. C. The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.
4. 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. — đáp án hiện tại