IBM Exam Questions

What would be a reason for altering the clustering index of a table?

What would be a reason for altering the clustering index of a table?

A.
To increase free space.

B.
Because the clustering index has to match the primary index.

C.
To choose a clustering index to favor batch sequential processing.

D.
To choose a clustering index to promote sequential inserts at the end of the table space.

Explanation: