Exit C2090-541 DB2 9.7 DBA for Linux UNIX and Windows
Question 3 of 5
0% complete
Q3 Single choice

Index TAB 1X1 was created as shown below: CREATE INDEX tablxl ON tab1(col_1)

Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?

  • A

    ALTER INDEX tablxl ADD COLUMN (col_2)

  • B

    ALTER INDEX tablxl CLUSTER

  • C

    ALTER INDEX tablxl COMPRESS YES

  • D

    ALTER INDEX tablxl PCTFREE 40

Previous Next