IBM Exam Questions

What statement regarding Asynchronous index cleanup (AIC) is correct?

What statement regarding Asynchronous index cleanup (AIC) is correct?

A.
AIC removes all invalid index entries that refer to the attached partitions.

B.
AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.

C.
AIC activates a newly attached partition after the index entries have been synchronized.

D.
AIC will not be initiated if a range-partitioned table has dependent materialized query tables
–(MQTs).

Explanation: