Câu 33: C2090-611: DB2 10.1 DBA for Linux UNIX and Windows

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?

1. A. CREATE INDEX tab1_idx ON tab1(col1); — đáp án hiện tại
2. B. CREATE INDEX tab1_idx ON tab1(col1);ALTER INDEX tab1_idx COMPRESS YES;
3. C. CREATE INDEX tab1_idx ON tab1(col1);REORG INDEX tab1_idx FOR TABLE tab1;
4. D. CREATE INDEX tab1_idx ON tab1(col1);ALTER INDEX tab1_idx COMPRESS YES;REORG INDEX tab1_idx FOR TABLE tab1;