DB2 10 for z/OS Database Administrator — Question 39

Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

Answer options

• A. ALTER TABLE tab1 APPEND ON
• B. ALTER TABLE tab1 DROP COLUMN col1
• C. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
• D. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1
• E. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

Correct answer: B, C

Explanation

The correct answers are B and C because both commands modify the structure of the table in ways that require reorganization. Option A, D, and E do not trigger a reorg-pending state; they either add data, detach partitions, or create constraints, which do not necessitate such a state.