IBM Exam Questions

Which ALTER TABLE statement will generate a new table space version?

Which ALTER TABLE statement will generate a new table space version?

A.
ALTER TABLE … ADD PARTITION …

B.
ALTER TABLE … ADD COLUMN COL2 …

C.
ALTER TABLE … DATA CAPTURE CHANGES …

D.
Altering an already existing VARCHAR column on the table to shorten its maximum length.

Explanation: