Learning Visually with Examples [Electronic resources]

Besides crash recovery, what are the other two types of recoveries?

In DB2 Version 8.2, you can back up the logs along with the database. What option allows you do that?

When are secondary logs created and destroyed?

What condition triggers the logs to be flushed from the log buffer to log files?

What is the maximum log space you can configure for a database?

What tool can you use to inspect a database while it is online?

What should you do when you find out that an index is corrupted?

How do you determine the minimum recovery time for a table space?

Which of the following requires manual archival and retrieval of log files?

1. USEREXIT

2. DISK

3. LOGRETAIN

4. VENDOR

A Unit of Work consists of one or more statements, and is terminated by which of the following?

1. COMMIT

2. TERMINATE

3. RESET

4. ROLL BACK

Which of the following is the default logging method used by DB2?

1. Infinite logging

2. Circular logging

3. Archival logging

4. Round-robin logging

Which of the following database configuration parameters specifies the size of log files?

1. LOGPRIMARY

2. LOGSECOND

3. LOGFILSIZ

4. LOGARCHMETH1

Which of the following database configuration parameters specifies a temporary target for archiving logs when the primary targets are not available?

1. LOGARCHMETH1

2. LOGARCHMETH2

3. FAILARCHPATH

4. LOGARCHOPT2

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?

1. Table space backups

2. Buffer pools

3. Logs

4. Database snapshot output

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?

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

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

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

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

Which of the following activates infinite active log space?

1. Logsecond = 0

2. Logprimary = 0

3. Logsecond =-1

4. Logprimary = -1

Which of the following configuration parameters enables online backups?

1. Logsecond = 0

2. Logarchmeth1 = off

3. Logarchmeth1 = logretain

4. Mirror log path = userexit

Which of the following configuration parameters enables table space backups?

1. Logsecond = 0

2. Logarchmeth1 = off

3. Logarchmeth1 = logretain

4. Mirror log path = userexit

Which of the following is not allowed during a redirected restore?

1. Change from DMS file to DMS raw containers

2. Change from DMS file to SMS containers

3. Change the number of containers in an SMS table space

4. Change the number of containers in a DMS table space

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?

1. The time on the client

2. The time on the server

Which of the following is not a valid option for the

db2inidb command?

1. Standby

2. Mirror

3. Snapshot

4. Backup

To create a backup image of the source database using split mirror, which of the following options should be used?

1. Standby

2. Mirror

3. Snapshot

4. Backup