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 contain 3 partitions; the first partition will be stored in table
space TBSP0, the second in TBSP1, and the third inTBSP2.

B.
The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in
table space TBSP3.

C.
The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space
TBSP3.

D.
The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space
TBSP0.


Leave a Reply