READ Free Dumps For IBM- A2090-612
Question ID 22438 | A single table should allow for up to 100 Terabytes of application data. How do you design your table space? |
Option A | A segmented compressed table space, BUFFERPOOL BP0. |
Option B | A LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0. |
Option C | A table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0. |
Option D | A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K. |
Correct Answer | D |
Question ID 22439 | For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES? |
Option A | Catalog tables |
Option B | Directory tables |
Option C | Auxiliary tables |
Option D | Declared global temporary tables |
Correct Answer | A |