READ Free Dumps For IBM- 000-611
Question ID 19941 | Which statement describes adaptive row compression? |
Option A | Adaptive compression allows for use of customized compression dictionary creation algorithms. |
Option B | Adaptive compression maintains a dynamic and ever changing table-level row compression dictionary. |
Option C | Adaptive compression incorporates both classic table-level row compression and page-by-page based |
Option D | Adaptive compression incorporates four compression approaches: tablespace-level, table-level, pagelevel, |
Correct Answer | C |
Question ID 19942 | If the following statement is executed: What indexes will be created for table TAB1? |
Option A | 1 dimension-block index and 1 composite-block index |
Option B | 1 dimension-block index and 3 composite-block indexes |
Option C | 3 dimension-block indexes and 1 composite-block index |
Option D | 3 dimension-block indexes and 3 composite-block indexes |
Correct Answer | C |