nerdexam
IBM

C2090-600 · Question #5

C2090-600 Question #5: Real Exam Question with Answer & Explanation

Sign in or unlock C2090-600 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.

Question

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

Options

  • 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) Answer: BC

Unlock C2090-600 to see the answer

You've previewed enough free C2090-600 questions. Unlock C2090-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full C2090-600 Practice