| 1: | What isolation level acquires no row-level locks? |
| 2: | What is the maximum requester I/O block size? |
| 3: | How can you eliminate the need for the first connections to a database to create their own agent process? |
| 4: | When will a database's log buffer be written to disk? |
| 5: | When does lock escalation occur? |
| 6: | When can you capture the statistics about your tables and indexes? |
| 7: | What command can be used to remove overflow records from your tables? |
| 8: | What monitor switch is enabled by default in Version 8? |
| 9: | What command resets the counters reported by the database snapshot command? |
| 10: | What objects must exist in your database in order to use the visual explain tool? |
| 11: | Which of the following commands cannot update the statistical information about tables and indexes in your database? runstats load reorgchk import
|
| 12: | Which of the following does not cause the log buffer to be written to disk? When the log buffer becomes full One second since the last time the log buffer was written to disk When applications issue MINCOMMIT commit statements When the percentage of the log buffer reaches SOFTMAX
|
| 13: | When lock escalation occurs, row-level locks are converted to which of the following? Page-level locks Extent-level locks Table-level locks Table space-level locks
|
| 14: | Which of the following configuration parameters allows DB2 to detect that pages are being read in order and automatically trigger prefetching? DETECT_PREFETCH SEQ_DETECT ENABLE_PREFETCH SCAN_DETECT
|
| 15: | Which two of the following configuration parameters control when the page cleaners will be triggered to write dirty pages from the buffer pool to disk? NUM_IOCLEANERS SOFTMAX DIRTY_THRESH CHNGPGS_THRESH MAX_LOG
|
| 16: | Which of the following commands will indicate that you need to reorganize your tables because they contain too many overflow records? reorgchk runstats inspect check
|
| 17: | Which of the following SQL statements can cause an overflow record to be created by DB2? insert update delete reorg
|
| 18: | Which of the following steps is not performed by the optimizer when building the access plan for an SQL statement? Query rewrite Check query semantics Parse the query Apply hints
|
| 19: | Which of the following is not an operator that you will see in a DB2 access plan? IXSCAN TBSCAN RIDSCN DTSCAN
|
| 20: | Given the following database configuration information: Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 1000 Sort list heap (4KB) (SORTHEAP) = 256
what is the maximum number of concurrent shared sorts than can occur without causing the sort to overflow? 1 2 3 4
|
