IBM Exam C2090-600 Topic 4 Question 34 Discussion

Actual exam question for IBM's C2090-600 exam

Question #: 34
Topic #: 4

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

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)

Show Suggested Answer

Suggested Answer: B, C

by Viva at Sep 19, 2022, 11:39 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!