IBM Exam Questions

What indexes will be created for table TAB1?

If the following statement is executed: What indexes will be created for table TAB1?

A.
1 dimension-block index and 3 composite-block indexes

B.
3 dimension-block indexes and 1 composite-block index

C.
1 dimension-block index and 1 composite-block index

D.
3 dimension-block indexes and 3 composite-block indexes