READ Free Dumps For IBM- C2090-612
Question ID 20494 | A table space is in AREO*. What does this status mean? |
Option A | A full image copy of the tablespace must be taken. |
Option B | The table space should be reorganized for optimal performance. |
Option C | A START command must be issued to remove it from the pending status. |
Option D | The table space must be reorganized to materialize all pending changes. |
Correct Answer | B |
Question ID 20495 | A single table should allow for up to 100 Terabytes of application data. How do you design |
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 |