IBM Exam C2090-600 Topic 11 Question 33 Discussion

Actual exam question for IBM's C2090-600 exam

Question #: 33
Topic #: 11

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 Sue at Aug 21, 2022, 01:25 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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