Self Test #3: Backup and Recovery Workshop (Chapters 11-15)
Welcome to the Interactive Self-Study Module. This page contains all of the review questions from the end of each chapter. Read the question, then click on the appropriate answer. A correct answer will link you to the next question.
If you need further review of the topic, click on the 
icon to link to
the appropriate section in the electronic book.
Chapter 11 Self Test
1. Which of the following scenarios will most likely result in the need for media recovery?
A. Machine failure as a result of a CPU crash
B. Disk failure that makes several tablespaces unavailable C. A broken disk controller D. A defective memory board 2. A decrease in the transaction activity level for a database
A. Decreases the amount of redo log activity for the database B. Increases the amount of redo log activity for the database C. Doubles the amount of redo log activity for the database D. Has no effect on the redo log activity for the database 3. In order to recover data to the point of failure, the DBA must first import the lost database objects, then apply archived redo logs.
A. TRUE B. FALSE 4. A good plan for backups of a read only tablespace may include which of the following?
A. Weekly offline backups and nightly data exports B. Weekly data exports and monthly offline backups C. Backing up the read only tablespace once D. Backing up the read only tablespace daily 5. Which three of the following are effects of archiving?
A. No potential for recovery to point of failure B. Ability to recover the database to a point in time after the last backup C. LOG_ARCHIVE_DEST must be set in init.ora D. Ability to take online backups 6. The number of archived redo logs produced by a database is most closely related to
A. The number of tables in the database B. The amount of time required to execute one transaction C. The number of hours per day the database is available D. The number of transactions taking place on the database 7. Which of the following backup strategies would be most appropriate for a database with users in 12 time zones?
A. Logical database backups with archiving disabled B. Online backups with archiving enabled C. Offline backups with archiving enabled D. Offline backups with archiving disabled 8. In order to take an offline backup using operating system tools, the DBA should first shut down the database using NORMAL or IMMEDIATE mode.
A. TRUE B. FALSE 9. Which three of the following objects are backed up using EXPORT?
A. Tablespaces B. Sequences C. Redo logs D. Indexes 10. What command is used to begin an online tablespace backup?
A. alter system begin backup B. alter tablespace begin backup C. alter database noarchivelog D. alter tablespace end backup 11. Which of the following is not a benefit of testing backup and recovery?
A. Uncovering hidden corrupt data in the database propagating itself into backups B. Improving the performance of the overall recovery strategy C. Uncovering weaknesses in the backup strategy and resolving them D. Archiving unused data from retired applications 12. For a database with few users and minimal data change, enabling archiving would probably be overkill.
A. TRUE B. FALSE 13. Which of the following backup options is viable for databases that are used primarily during the hours of 8 A.M. and 5 P.M.?
A. Logical backups with archiving enabled. B. Offline backups with archiving disabled. C. Offline backups with archiving enabled. D. No backup strategy is required for this scenario.
Chapter 12 Self Test
1. The DBA is conducting an export. Which of the following actions guarantees read consistency during all types of exports?
A. Setting CONSISTENT=Y in the parameter file for the export B. Issuing the alter system enable restricted session statement C. Issuing startup mount on the database D. Issuing shutdown abort on the database 2. Setting the value of the BUFFER parameter to zero will allow EXPORT to
A. Export row data from the database continuously B. Export no row data from the database C. Export row data from the database in one try D. Export row data from the database, one row at a time 3. Which of the following two options are valid values for INCTYPE during a run of IMPORT? (Choose two)
A. complete B. cumulative C. system D. incremental E. restore 4. To export the indexes, constraints, and triggers associated with only one particular table, the DBA should use which set of parameters?
A. USERS=Y, INDEXES=Y, CONSTRAINTS=Y, TRIGGERS=Y B. OWNERS=Y, INDEXES=Y, CONSTRAINTS=Y, TRIGGERS=Y C. TABLES=Y, INDEXES=Y, CONSTRAINTS=Y, TRIGGERS=Y D. FULL=Y, INDEXES=Y, CONSTRAINTS=Y, TRIGGERS=Y 5. IMPORT can only import export files that are the same character set as the target database.
A. TRUE B. FALSE 6. The DBA is about to run IMPORT. The first step for database recovery using IMPORT should always be
A. Apply the most recent complete export B. Apply all cumulative exports C. Apply all incremental exports D. Apply the most recent export of any type 7. Which of the following lists only the mandatory parameters set for the first step of database recovery using IMPORT?
A. BUFFERS, USERID, FILE B. FILE, FULL, TABLE C. FILE, FULL, INCTYPE D. CONSISTENT, FROMUSER, TOUSER 8. Instance recovery is handled
A. Manually with intervention from the DBA B. Automatically using PMON C. Automatically using ARCH D. Automatically using SMON 9. Process failure can occur when
A. The user issues the CTRL-C command B. The user misspells the name of the table in the from clause C. The user does not have object privileges on the database object D. The database object does not exist 10. If the objects imported into a database are owned by a schema that doesn't exist on the target database, which of the following parameters should be set?
A. CONSISTENT B. USERID C. TOUSER D. OWNER 11. Setting DIRECT=Y will cause EXPORT to use the conventional path.
A. TRUE B. FALSE 12. Setting INCTYPE=SYSTEM on the first import is crucial to the success of database recovery using IMPORT.
A. TRUE B. FALSE
Chapter 13 Self Test
1. The type of failure most likely to require recovery from backup is
A. User error B. Statement failure C. Process failure D. Instance failure 2. ALTER DATABASE RECOVER AUTOMATIC begins automatic archiving.
A. TRUE B. FALSE 3. After executing which three situations should the DBA consider backing up the datafiles of a database?
A. Changing a read-write tablespace to read only status. B. Changing a database to archivelog mode. C. After a database experiences many data changes. D. After substantial numbers of tables are added to the database. 4. The integer assigned to each transaction that takes place in the database is called a
A. Sequence number B. Thread number C. System change number D. Userid number 5. To put the database into ARCHIVELOG mode, the DBA should issue the ____ statement.
A. alter database archivelog; B. alter system archivelog; C. alter database archive log start; D. alter system archive log start; 6. Which view contains information about the archiving mode of the database?
A. V$LOG B. V$LOGFILE C. V$LOG_HISTORY D. V$DATABASE 7. In order to provide a consistent view of the database, the DBA should restore only damaged files when recovering a database from a full, offline backup.
A. TRUE B. FALSE 8. Which two of the following parameters must be set for using automatic archiving?
A. LOG_ARCHIVE_DEST B. BACKGROUND_DUMP_DEST C. LOG_ARCHIVE_FORMAT D. LOG_ARCHIVE_TIME 9. The name of the background process that handles archiving redo logs is
A. LGWR B. DBWR C. ARCH D. RECO 10. To selectively archive a redo log entry according to the sequence number, which of the following statements should be issued?
A. alter system archive log start; B. alter database archive log; C. alter system archive log seq 34; D. alter system archive log current; 11. To view the list of archived redo logs, which operation is appropriate?
A. Archive log list B. select * from v$log_history; C. alter system list archive logs; D. select * from log; 12. If automatic archiving is not enabled, what will happen on a database in ARCHIVELOG mode if the DBA does not archive in a timely manner?
A. Nothing, archiving is handled automatically. B. Database performance will degrade slightly. C. Database performance will degrade substantially, but will not stop. D. The database will not be able to accept any more changes until archiving occurs. 13. Automatic archiving is enabled. An example filename for a redo log archived is Rdo-3-0003.arc. What is the value for LOG_ARCHIVE_FORMAT?
A. ARCH%T%s.arc B. Rdo%T-%s.arc C. Rdo-%t-%S.arc D. Rdo%t%s.arc 14. Archived redo logs can be applied to a database if the database was restored from a backup taken when the database was in NOARCHIVELOG mode.
A. TRUE B. FALSE 15. To discard redo logs and set the sequence number back to 1 upon opening the database, the DBA should use which of the following options?
A. archivelog B. resetlogs C. exclusive D. parallel 16. The interactive aspect of database recovery can be eliminated with the use of which of the following options to the ALTER DATABASE statement?
A. archivelog B. resetlogs C. automatic D. start
Chapter 14 Self Test
1. Characteristics of a change-based recovery include
A. Recovery to the point in time of a database failure B. Usage of the recover tablespace option C. Recovery by system change number D. Availability of the database during recovery 2. The DBA takes a backup of the control file daily. A situation arises where the control file must be recovered. To do so, the DBA uses the CREATE CONTROLFILE statement in conjunction with her backup. Which of the following correctly describes her control file backup methods?
A. The DBA's backup method for control files puts the backup in a trace directory. B. The DBA's backup method for control files creates a usable control file. C. The DBA's backup method for control files uses an alter tablespace statement. D. The DBA's backup method for control files uses the alter database backup controlfile to dbase.ctl statement. 3. In order to execute a complete recovery using a full backup, the DBA should first
A. Open the database in restricted session mode B. Restore only the damaged datafiles from backup C. Use resetlogs to reset the redo log sequence D. Mount but not open the database 4. The DBA must perform incomplete recovery. Characteristics of a cancel-based recovery include
A. Automatic application of Oracle's archive redo suggestions B. Use of the alter database recover database until cancel statement C. Tablespace recovery with online backups D. Availability of the database during the recovery process 5. When conducting online backups, it is usually best to take backups of tablespaces in parallel.
A. TRUE B. FALSE 6. The DBA is conducting a closed database recovery using full offline backups. The DBA realizes that archived redo log sequence #34 is missing. What can the DBA do to execute the proper recovery?
A. Check the V$LOG view to find the beginning SCN for log sequence 34, then issue the alter database recover tablespace until change 34 statement. B. Issue the alter database recover database using backup controlfile statement. C. Check V$LOG_HISTORY for the beginning SCN of log 34, issue alter database recover database until change N, where N equals the beginning SCN minus 1 for log 34. D. Use IMPORT to recover the database from the most recent database export. 7. Which of the following RECOVER DATABASE statements should not use the AUTOMATIC option?
A. until change 495893 B. until '2000-01-31:22:34:00' C. until resetlogs 1 D. until cancel 8. The RECOVER DATABASE method requires that the database not be available to users during recovery.
A. TRUE B. FALSE 9. Three characteristics of offline backups are
A. Complete set of all files in the Oracle database B. Obtained after issuing the alter system enable restricted session statement C. Taken when the database is closed D. Used in conjunction with incomplete recovery 10. If the DBA must re-create the control file as part of database recovery, she should do it
A. After opening the database B. After backup datafile restoration C. Between restoring backups and applying redo logs D. Before closing the database to user access 11. A system change number is
A. The number assigned to every redo log in the database B. The number of each transaction executed in the database C. The number of every user created in the database D. The number of each backup taken of the database 12. Which of the following steps is inappropriate for complete recovery?
A. Mount the database in exclusive mode B. Restore backup copies of datafiles C. Issue the cancel command when the DBA runs out of redo to apply D. Open the database using the resetlogs option 13. Which of the following are characteristics of online backups? (Choose two)
A. Initiated with alter tablespace begin backup statement B. Run on databases in archivelog mode C. Contain all files for the database D. Contain only changes made since last backup 14. Incomplete recovery can be accomplished with the RECOVER TABLESPACE statement.
A. TRUE B. FALSE 15. Which of the following recovery methods require use of archiving? (Choose three)
A. Recovery from full offline backup B. Cancel-based recovery C. Complete recovery D. Change-based recovery
Chapter 15 Self Test
1. In order to detect online redo log corruption, the DBA should
A. Run DBVERIFY on the redo log file B. Run DBVERIFY on the datafile C. View the contents using Server Manager D. Set LOG_ARCHIVE_CHECKSUM to TRUE 2. Which of the following statements is appropriate for creating a control file for a standby database?
A. Alter database backup controlfile to 'orgstby.ctl'; B. Alter database backup controlfile to standby; C. Alter database backup standby controlfile to 'orgstby.ctl'; D. Alter database create controlfile; 3. The DBA believes there is a media failure on the disk containing the DATA01 tablespace. In the trace file for which background process might the DBA look for an error message?
A. LGWR B. DBWR C. SMON D. PMON 4. Which of the following statements is used to recover the database when the DBA wants to let users access undamaged areas of the database while recovery takes place?
A. recover tablespace B. recover database C. recover parallel D. recover until cancel 5. If archiving has stopped due to corruption of a data block in all redo log members, which of the following statements is appropriate for resolving the problem?
A. shutdown abort B. alter database archivelog C. alter database clear unarchived logfile group D. alter system archive log current 6. Archiving must be used in conjunction with the standby database.
A. TRUE B. FALSE 7. Which of the following items most directly improves the performance of parallel recovery?
A. Synchronous I/O B. Decreasing instances C. Decreasing degree D. Increasing RECOVER_PARALLELISM 8. To identify the time archiving was turned off, the DBA should use
A. The V$LOG view B. The alert log C. The V$LOGFILE view D. The redo log 9. Which of the following is most likely the reason why a database starts faster after system failure?
A. Hardware upgrade B. Lower memory usage C. The DBVERIFY utility D. Fast transaction rollback 10. Multiplexing redo log members reduces the possibility of having to clear an online redo log.
A. TRUE B. FALSE 11. If RECOVERY_PARALLELISM=15, which of the following are appropriate settings for parallel recovery?
A. instances=4, degree=4 B. instances=2, degree=5 C. instances=3, degree=6 D. instances=5, degree=4