Home > Articles > Data > DB2

  • Print
  • + Share This
This chapter is from the book

Practice Questions

Question 1

Which of the following is the primary purpose for using infinite logging?

  • A. Eliminate the need to archive log files as they become full.

  • B. Eliminate the need to specify the number of primary log files used.

  • C. Eliminate the need to specify the size of all log files used.

  • D. Support large transactions whose logging activity would normally exceed the space provided by primary and secondary log files.

Question 2

Which of the following is NOT supported when LOGRETAIN is set to RECOVERY and USEREXIT is OFF?

  • A. Circular logging

  • B. Archival logging

  • C. Roll-forward recovery

  • D. Crash recovery

Question 3

When attempting to connect to a database named SAMPLE, the following message is displayed:

SQL1015N The database must be restarted because the previous session did not conclude normally.

In order to correct the situation, which of the following should be performed?

  • A. RESTORE DATABASE sample

  • B. RESTART DATABASE sample

  • C. RECOVER DATABASE sample

  • D. RESET DATABASE sample

Question 4

Some of a database's indexes need to be rebuilt. To minimize application response time, which of the following is the correct setting of the INDEXREC database configuration parameter?

  • A. ACCESS

  • B. RESTART

  • C. IMMEDIATE

  • D. DEFERRED

Question 5

The REDIRECT option of the RESTORE command is used to do which of the following?

  • A. Restore a database to a location that is different from its original location.

  • B. Restore a database whose tablespace containers reference invalid drives/devices.

  • C. Restore a database and at the same time, convert all DMS tablespaces to SMS tablespaces.

  • D. Restore a database and at the same time, convert all SMS tablespaces to DMS tablespaces.

Question 6

The following commands have been entered:

UPDATE DB CFG FOR sample USING LOGRETAIN YES IMMEDIATE
BACKUP DB sample TO c:\backups
CONNECT TO sample
INSERT INTO department (deptid, deptname) VALUES ('001', 'RESEARCH')
RESTORE DB sample FROM c:\backups

Which two of the following commands can be issued to make the SAMPLE database usable?

  • A. RESTART DB sample

  • B. ROLLFORWARD DB sample to END OF LOGS

  • C. ROLLFORWARD DB sample COMPLETE

  • D. ROLLFORWARD DB sample to END OF LOGS AND STOP

  • E. ROLLFORWARD DB sample CONTINUE

Question 7

Given the following command:

RESTORE DATABASE sample FROM c:\backups

Which of the parameters determines how much buffer space will be used to restore the SAMPLE database?

  • A. logbufsz

  • B. buffpage

  • C. restbufsz

  • D. util_heap_sz

Question 8

Given that the USEREXIT configuration parameter for a database is set to YES, which of the following configuration parameters must be set to enable infinite logging?

  • A. LOGPRIMARY = –1

  • B. LOGSECOND = –1

  • C. LOGFILSIZ = –1

  • D. LOGRETAIN = –1

Question 9

Which combination of database configuration parameters make a database non-recoverable?

  • A. LOGRETAIN=RECOVERY; USEREXIT=YES

  • B. LOGRETAIN=NO; USEREXIT=YES

  • C. LOGRETAIN=RECOVERY; USEREXIT=NO

  • D. LOGRETAIN=NO; USEREXIT=NO

Question 10

When does a log file become an off-line archived log file?

  • A. When it is moved from the active log directory

  • B. When it is no longer needed for crash recovery

  • C. When it is full and a new log is being processed

  • D. When it becomes full

Question 11

Given the following command:

ROLLFORWARD DATABASE sample TO 2003-01-01-00.00.00.0000 AND STOP

How is the time 2003-01-01-00.00.00.0000 interpreted by the ROLLFORWARD command?

  • A. As a local time value

  • B. As a coordinated universal time (UTC) value

  • C. As a timestamp value

  • D. As a world time value

Question 12

Which of the following configuration parameters enables dual logging for a database?

  • A. newlogpath

  • B. seconglogpath

  • C. mirrorlogpath

  • D. overflowlogpath

Question 13

Which of the following occurs when the command SET WRITE SUSPEND FOR DATABASE is issued?

  • A. All tablespace writes are suspended; all log writes are suspended; and all database operations continue to function normally.

  • B. All tablespace writes are suspended and all database operations continue to function normally.

  • C. All tablespace writes are suspended; all log writes are suspended; and all database operations other than online backup and restore operations continue to function normally.

  • D. All tablespace writes are suspended and all database operations other than online backup and restore operations continue to function normally.

Question 14

An incremental backup image contains which of the following?

  • A. A copy of all data and index changes made since the last successful backup (full, incremental, or delta) was made.

  • B. A copy of all data and index changes made since the last successful full backup image was made.

  • C. A copy of all data, index, and database meta-data that has changed since the last successful backup (full, incremental, or delta) was made.

  • D. A copy of all data, index, and database meta-data that has changed since the last successful full backup image was made.

Question 15

Which of the following commands will produce just a list of all backup operations performed on a database named SAMPLE?

  • A. LIST HISTORY BACKUP ALL FOR sample

  • B. LIST BACKUP HISTORY FOR sample

  • C. LIST ALL BACKUP HISTORY FOR sample

  • D. LIST RECOVERY FILE BACKUP HISTORY FOR sample

Question 16

An offline database backup that was started for a database named SAMPLE at 1:00 AM local time completed at 2:30 AM local time. Assuming the SAMPLE database is a recoverable database, and that it is now 11:30 AM, which of the following commands must be performed in order to restore the SAMPLE database to the state it was in at 2:30 this morning?

  • A. RESTORE DATABASE sample FROM c:\backups

  • B. RESTORE DATABASE sample FROM c:\backups ROLLFORWARD TO 02:30.00.000000 USING LOCAL TIME

  • C. RESTORE DATABASE sample FROM c:\backups WITHOUT ROLLING FORWARD

  • D. RESTORE DATABASE sample FROM c:\backups ROLLFORWARD STOP

  • + Share This
  • 🔖 Save To Your Account