PrepAway - Latest Free Exam Questions & Answers

Which statement(s) should be used to create an index on…

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);

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

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

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


Leave a Reply