Understanding DB2®: Learning Visually with Examples

16.14. Review Questions

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