13.15. Review Questions

1:Besides crash recovery, what are the other two types of recoveries?
2:In DB2 Version 8.2, you can back up the logs along with the database. What option allows you do that?
3:When are secondary logs created and destroyed?
4:What condition triggers the logs to be flushed from the log buffer to log files?
5:What is the maximum log space you can configure for a database?
6:What tool can you use to inspect a database while it is online?
7:What should you do when you find out that an index is corrupted?
8:How do you determine the minimum recovery time for a table space?
9:Which of the following requires manual archival and retrieval of log files?
  1. USEREXIT

  2. DISK

  3. LOGRETAIN

  4. VENDOR

10:A Unit of Work consists of one or more statements, and ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.