This chapter is from the book
This chapter is from the book
This chapter is from the book
Practice Questions
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.
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
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
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
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.
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
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
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
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
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
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
Which of the following configuration parameters enables dual logging for a database?
-
A. newlogpath
-
B. seconglogpath
-
C. mirrorlogpath
-
D. overflowlogpath
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.
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.
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
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