PrepAway - Latest Free Exam Questions & Answers

Which ALTER TABLE statements will put a table named TAB…

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

PrepAway - Latest Free Exam Questions & Answers

A.
ALTER TABLE tab1 APPEND ON

B.
ALTER TABLE tab1 DROP COLUMN col1

C.
ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL

D.
ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1

E.
ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)


Leave a Reply