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?
|
10: | A Unit of Work consists of one or more statements, and is terminated by which of the following?
|
11: | Which of the following is the default logging method used by DB2?
|
12: | Which of the following database configuration parameters specifies the size of log files?
|
13: | Which of the following database configuration parameters specifies a temporary target for archiving logs when the primary targets are not available?
|
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?
|
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?
|
16: | Which of the following activates infinite active log space?
|
17: | Which of the following configuration parameters enables online backups?
|
18: | Which of the following configuration parameters enables table space backups?
|
19: | Which of the following is not allowed during a redirected restore?
|
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?
|
21: | Which of the following is not a valid option for the db2inidb command?
|
22: | To create a backup image of the source database using split mirror, which of the following options should be used?
|