IBM
C2090-600 · Question #5
Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)
See the full explanation below for the reasoning.
Question
Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)
Options
- AALTER TABLE tab1 APPEND ON
- BALTER TABLE tab1 DROP COLUMN col1
- CALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
- DALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1
- EALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1) Answer: BC
Community Discussion
No community discussion yet for this question.