Learning Visually with Examples [Electronic resources]

What isolation level acquires no row-level locks?

What is the maximum requester I/O block size?

How can you eliminate the need for the first connections to a database to create their own agent process?

When will a database's log buffer be written to disk?

When does lock escalation occur?

When can you capture the statistics about your tables and indexes?

What command can be used to remove overflow records from your tables?

What monitor switch is enabled by default in Version 8?

What command resets the counters reported by the database snapshot command?

What objects must exist in your database in order to use the visual explain tool?

Which of the following commands cannot update the statistical information about tables and indexes in your database?

1. runstats

2. load

3. reorgchk

4. import

Which of the following does not cause the log buffer to be written to disk?

1. When the log buffer becomes full

2. One second since the last time the log buffer was written to disk

3. When applications issue MINCOMMIT commit statements

4. When the percentage of the log buffer reaches SOFTMAX

When lock escalation occurs, row-level locks are converted to which of the following?

1. Page-level locks

2. Extent-level locks

3. Table-level locks

4. Table space-level locks

Which of the following configuration parameters allows DB2 to detect that pages are being read in order and automatically trigger prefetching?

1. DETECT_PREFETCH

2. SEQ_DETECT

3. ENABLE_PREFETCH

4. SCAN_DETECT

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?

1. NUM_IOCLEANERS

2. SOFTMAX

3. DIRTY_THRESH

4. CHNGPGS_THRESH

5. MAX_LOG

Which of the following commands will indicate that you need to reorganize your tables because they contain too many overflow records?

1. reorgchk

2. runstats

3. inspect

4. check

Which of the following SQL statements can cause an overflow record to be created by DB2?

1. insert

2. update

3. delete

4. reorg

Which of the following steps is not performed by the optimizer when building the access plan for an SQL statement?

1. Query rewrite

2. Check query semantics

3. Parse the query

4. Apply hints

Which of the following is not an operator that you will see in a DB2 access plan?

1. IXSCAN

2. TBSCAN

3. RIDSCN

4. DTSCAN

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. 1

2. 2

3. 3

4. 4