Section 13.15. Review Questions


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 is terminated by which of the following?

  1. COMMIT

  2. TERMINATE

  3. RESET

  4. ROLL BACK

11:

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

12:

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

  1. LOGPRIMARY

  2. LOGSECOND

  3. LOGFILSIZ

  4. LOGARCHMETH1

13:

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

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?

  1. Table space backups

  2. Buffer pools

  3. Logs

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

  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 

16:

Which of the following activates infinite active log space?

  1. Logsecond = 0

  2. Logprimary = 0

  3. Logsecond =-1

  4. Logprimary = -1

17:

Which of the following configuration parameters enables online backups?

  1. Logsecond = 0

  2. Logarchmeth1 = off

  3. Logarchmeth1 = logretain

  4. Mirror log path = userexit

18:

Which of the following configuration parameters enables table space backups?

  1. Logsecond = 0

  2. Logarchmeth1 = off

  3. Logarchmeth1 = logretain

  4. Mirror log path = userexit

19:

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

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?

  1. The time on the client

  2. The time on the server

21:

Which of the following is not a valid option for the db2inidb command?

  1. Standby

  2. Mirror

  3. Snapshot

  4. Backup

22:

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



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net