PrepAway - Latest Free Exam Questions & Answers

Which statement about the PARTS_IDX index is true?

A partitioned table named SALES was created as follows:

Which statement about the PARTS_IDX index is true?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply