IBM Exam C2090-600 Topic 10 Question 9 Discussion

Actual exam question for IBM's C2090-600 exam

Question #: 9
Topic #: 10

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 Brock at May 09, 2022, 09:15 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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