IBM Exam C2090-600 Topic 9 Question 35 Discussion

Actual exam question for IBM's C2090-600 exam

Question #: 35
Topic #: 9

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 Willodean at Oct 12, 2022, 07:10 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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