IBM Exam C2090-600 Topic 1 Question 27 Discussion

Actual exam question for IBM's C2090-600 exam

Question #: 27
Topic #: 1

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 Mattie at May 05, 2022, 11:01 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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