IBM Exam Questions

When will the existing data for a new partition be visible to applications querying a rangepartition

When will the existing data for a new partition be visible to applications querying a rangepartitioned table?

A.
After the ALTER TABLE … ADD statement is executed.

B.
After the ALTER TABLE … ATTACH statement is executed.

C.
After the ALTER TABLE … ADD and SET INTEGRITY statements are executed.

D.
After the ALTER TABLE … ATTACH and SET INTEGRITY statements are executed.

Explanation: