PrepAway - Latest Free Exam Questions & Answers

Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for compress

Table TAB1 was created as follows: Which statement(s) should be used to create an index
on column COL1 of table TAB1 that is enabled for compression?

PrepAway - Latest Free Exam Questions & Answers

A.
CREATE INDEX tab1_idx ON tab1(col1); ALTER INDEX tab1_idx COMPRESS YES;

B.
CREATE INDEX tab1_idx ON tab1(col1); REORG INDEX tab1_idx FOR TABLE tab1;

C.
CREATE INDEX tab1_idx ON tab1(col1);

D.
CREATE INDEX tab1_idx ON tab1(col1); ALTER INDEX tab1_idx COMPRESS YES;
REORG INDEX tab1_idx FOR TABLE tab1;


Leave a Reply