READ Free Dumps For IBM- C2090-311
| Question ID 20875 | What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track? |
| Option A | The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed. |
| Option B | The number of times a temporary error occurred while trying to queue a column- organized prefetch request for a regular table space. |
| Option C | The number of times DB2 had to retrieve a page from disk for a temporary column- organized table because the page no longer resided in the buffer pool. |
| Option D | The number of times an asynchronous read request failed when attempting to read temporary column-organized data from the buffer pool after the page had been flushed to disk. |
| Correct Answer | B |
| Question ID 20876 | What type of table can be converted into a column-organized table with the db2convert |
| Option A | A range partitioned table |
| Option B | A materialized query table |
| Option C | A row-organized user table |
| Option D | A declared global temporary table |
| Correct Answer | A |