#1. Your database is in ARCHIVELOG mode, and you want to recover from a media failure up to the time of
failure. Which files do you need to restore?
A. the damaged files from any valid backup
B. the damaged files from a backup taken after the database was set in ARCHIVELOG mode
C. the damaged files and the redo-log files from a backup taken after the database was set in ARCHIVELOG
mode
D. the damaged files, the redo-log files, and the control files from a backup taken after the database was set
in ARCHIVELOG mode
Answer: B
#2. While performing a database recovery, you want the redo-log files to be applied automatically. What are three
ways to do that? (Choose three.)
A. enter the word AUTO when prompted for a log
B. set the AUTO_ARCHIVE_LOG initialization parameter
C. use the AUTOMATIC clause of the RECOVER command
D. within SQL*plus, issue the SET AUTORECOVERY ON command
Answer:A,C,D
#3. To successfully recover when restoring a backup control file to a different location, what must you do?
A. update the initialization parameter file
B. use the ALTER SYSTEM command to rename the control file
C. use the ALTER DATABASE command to rename the control file
D. You cannot do this; control files should always be restored to their original location.
Answer: A
#4. Your archived logs are not restored to the ARCHIVE_LOG_DEST directory. What are three ways to notify the
Oracle server of their location? (Choose three.)
A. specify the location and name when prompted for a log
B. use the ALTER SYSTEM SWITCH LOGFILE command
C. use the RECOVER FROM command to indicate the new location
D. use the ALTER SYSTEM ARCHIVE command to indicate the new location
Answer: A,C,D
#5. Your database is in NOARCHIVELOG mode, and a media failure occurs. Which files do you need to restore to
minimize data loss?
A. the damaged files only
B. the damaged files only if no log switch has occured since the last backup
C. all data files that are consistenet from the same backup set if a log switch has occured since the last
backup
D. all data files that can be a mix from any backup set if a log switch has occured since the last backup (You
can take them from different backup sets if you like.)
Answer: B
#6. You perform an incomplete database recovery using RMAN. Which state of the target database is needed?
A. mount
B. nomount
C. open, initially open
D. open, initially closed
Answer: A
#8. Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true?
A. Recovery Manager requires a recovery catalog.
B. Recovery Manager supports multi-level incremental backups.
C. Recovery Manager is compatible with Enterprise Backup utility.
D. Recovery Manager only works in conjunction with a tape subsystem.
Answer: C
#9. Before you can restore data files to a new location using RMAN, what should you do?
A. issue the SWITCH command
B. issue the RESTORE command
C. take the data files that you need to restore offline
D. copy the data files to the new location using an operating system tool
Answer: D
#10. What is the recommended initial size for a tablespace containing an RMAN recovery catalog?
A. 1M
B. 20M
C. 100M
D. 10% of the size of the target database
Answer: B
#11. After rebuilding the recovery catalog by resynchronizing it with a copy of the backup control file, you notice
references to files that no longer exist. Which CHANGE command clause should you use to remove these
references?
A. REMOVE
B. DELETE
C. UNCATALOG
D. CATALOG REMOVE
Answer: C
#12. What are two purposes for using the Recovery Manager command CATALOG? (Choose two.)
A. updating recovery catalog about rollback segment creation
B. updating recovery catalog about files created before RMAN
C. updating recovery catalog about operating system backups
D. updating recovery catalog about files created before Oracle8
E. updating recovery catalog about files that belong to a clone database
Answer: A,B
#13. What are two benefits of using RMAN with a catalog? (Choose two.)
A. You can copy the redo-log history into the control file.
B. You can store scripts for backup and recovery operations.
C. You can register the target database with recovery catalog.
D. You can maintain records of backup and recovery operations.
E. You can synchronize the recovery catalog and the target database.
Answer: B,C
#14. Your daily report indicating which data files need to be backed up has been misplaced. Which Recovery
Manager command returns a report containing the files in the USER_DATA tablespace that have not been backed
up within the last three days?
A. rman list backup days 3 tablespace user_data;
B. rman report backup days 3 tablespace user_data;
C. rman catalog backup days 3 tablespace user_data;
D. rman report need backup days 3 tablespace user_data;
Answer: D
#15. Which command is used to allow RMAN to store a group of commands in the recovery catalog?
A. ADD SCRIPT B. CREATE SCRIPT
C. CREATE COMMAND
D. ADD BACKUP SCRIPT
Answer: A
#16. Which statement about "time-based recovery" is true?
A. Recovery is stopped by entering CANCEL at the recovery prompt.
B. Recovery is stopped by pressing at the recovery prompt.
C. Recovery is stopped after the database has committed all changes up to the specified point-in-time.
D. Recovery is stopped when the database has committed all changes up to the specified system change
number(SCN).
E. Recovery is stopped when the specified method of recovery(CANCEL, TIME, or CHANGE) is completed,
and the control files are recovered.
Answer: C
#17. Which RECOVER command is appropriate when, while recovering a lost data file, a DBA discovers that a
required, archived redo-log is corrupted?
A. RECOVER DATABASE UNTIL CANCEL;
B. ALTER TABLESPACE system RECOVER;
C. RECOVER TABLESPACE system UNTIL CALCEL;
D. RECOVER DATABASE USING MISSING REDOLOG;
E. RECOVER DATABASE USING BACKUP CONTROLFILE;
Answer: A
#18. Which action does Oracle recommend after a DBA recovers from the loss of the current online redo-log?
A. back up the data files
B. back up the instance
C. back up the database
D. back up the control file
E. archive any unarchived online redo-logs
Answer: C
#19. Which statement is true when using the LogMiner utility?
A. The dictionary file is created in a directory as defined by UTL_FILE_DIR.
B. The CREATE DBMS LOGMNR command is used to build the dictionary file.
C. The dictionary file must be created after the log file analysis has completed.
D. The dictionary file is created as a backup if the data dictionary gets corrupted.
Answer: A
#20. Which option is used in the parameter file to detect corruptions in an Oracle data block?
A. DBVERIFY
B. DBMS_REPAIR
C. DB_BLOCK_CHECKING
D. VALIDATE_STRUCTURE
Answer: C
#21. The alter log can contain specific information about which database backup activity?
A. placing data files in begin and end backup mode
B. placing tablespaces in begin and end backup mode
C. changing the datab
