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?
|
12: | Which of the following does not cause the log buffer to be written to disk?
|
13: | When lock escalation occurs, row-level locks are converted to which of the following?
|
14: | Which of the following configuration parameters allows DB2 to detect that pages are being read in order and automatically trigger prefetching?
|
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?
|
16: | Which of the following commands will indicate that you need to reorganize your tables because they contain too many overflow records?
|
17: | Which of the following SQL statements can cause an overflow record to be created by DB2?
|
18: | Which of the following steps is not performed by the optimizer when building the access plan for an SQL statement?
|
19: | Which of the following is not an operator that you will see in a DB2 access plan?
|
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?
|