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? USEREXIT DISK LOGRETAIN VENDOR
| | 10: | A Unit of Work consists of one or more statements, and is terminated by which of the following? COMMIT TERMINATE RESET ROLL BACK
| | 11: | Which of the following is the default logging method used by DB2? Infinite logging Circular logging Archival logging Round-robin logging
| | 12: | Which of the following database configuration parameters specifies the size of log files? LOGPRIMARY LOGSECOND LOGFILSIZ LOGARCHMETH1
| | 13: | Which of the following database configuration parameters specifies a temporary target for archiving logs when the primary targets are not available? LOGARCHMETH1 LOGARCHMETH2 FAILARCHPATH LOGARCHOPT2
| | 14: | Given that you must restore a database from backup, which of the following objects must be available in order to recover the transactions performed after a backup was taken? Table space backups Buffer pools Logs Database snapshot output
| | 15: | Given the following database configuration information: Number of primary log files (LOGPRIMARY) = 5 Number of secondary log files (LOGSECOND) = 5 Path to log files = C:\logsforDB1\ which of the following correctly lists the contents of the C:\logsforDB1 directory immediately after issuing the activate database command for the database, if log retain is not enabled? Directory of C:\LOGSFORDB1\ 2004-03-10 06:06p 1,032,192 S0000000.LOG 2004-03-10 06:06p 1,032,192 S0000001.LOG 2004-03-10 06:06p 1,032,192 S0000002.LOG 2004-03-10 06:06p 1,032,192 S0000003.LOG 2004-03-10 06:06p 1,032,192 S0000004.LOG Directory of C:\MYLOGS\ 2004-03-10 06:06p 1,032,192 S0000001.LOG 2004-03-10 06:06p 1,032,192 S0000002.LOG 2004-03-10 06:06p 1,032,192 S0000003.LOG 2004-03-10 06:06p 1,032,192 S0000004.LOG 2004-03-10 06:06p 1,032,192 S0000005.LOG Directory of C:\LOGSFORDB1\ 2004-03-10 06:06p 1,032,192 S0000000.LOG 2004-03-10 06:06p 1,032,192 S0000001.LOG 2004-03-10 06:06p 1,032,192 S0000002.LOG 2004-03-10 06:06p 1,032,192 S0000003.LOG 2004-03-10 06:06p 1,032,192 S0000004.LOG 2004-03-10 06:06p 1,032,192 S0000005.LOG 2004-03-10 06:06p 1,032,192 S0000006.LOG 2004-03-10 06:06p 1,032,192 S0000007.LOG 2004-03-10 06:06p 1,032,192 S0000008.LOG 2004-03-10 06:06p 1,032,192 S0000009.LOG Directory of C:\MYLOGS\ 2004-03-10 06:06p 1,032,192 S0000001.LOG 2004-03-10 06:06p 1,032,192 S0000002.LOG 2004-03-10 06:06p 1,032,192 S0000003.LOG 2004-03-10 06:06p 1,032,192 S0000004.LOG 2004-03-10 06:06p 1,032,192 S0000005.LOG 2004-03-10 06:06p 1,032,192 S0000006.LOG 2004-03-10 06:06p 1,032,192 S0000007.LOG 2004-03-10 06:06p 1,032,192 S0000008.LOG 2004-03-10 06:06p 1,032,192 S0000009.LOG 2004-03-10 06:06p 1,032,192 S0000010.LOG
| | 16: | Which of the following activates infinite active log space? Logsecond = 0 Logprimary = 0 Logsecond =-1 Logprimary = -1
| | 17: | Which of the following configuration parameters enables online backups? Logsecond = 0 Logarchmeth1 = off Logarchmeth1 = logretain Mirror log path = userexit
| | 18: | Which of the following configuration parameters enables table space backups? Logsecond = 0 Logarchmeth1 = off Logarchmeth1 = logretain Mirror log path = userexit
| | 19: | Which of the following is not allowed during a redirected restore? Change from DMS file to DMS raw containers Change from DMS file to SMS containers Change the number of containers in an SMS table space Change the number of containers in a DMS table space
| | 20: | Given a DB2 client in the Central time zone, and a DB2 server in the Eastern time zone, when the command ROLLFORWARD DATABASE sample TO timestamp USING LOCAL TIME is issued on the client server, which time is used? The time on the client The time on the server
| | 21: | Which of the following is not a valid option for the db2inidb command? Standby Mirror Snapshot Backup
| | 22: | To create a backup image of the source database using split mirror, which of the following options should be used? Standby Mirror Snapshot Backup
|
|