#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 database backup
mode from open to close
D. performing an operating system backup of the database files
Answer: B
#22. Which statement is true when using the
DBVERIFY utility to detect corruptions in an Oracle data block?
A. The utility can only be invoked on a data file that is online.
B. The utility
can be used to verify the data files of a backup database.
C. The utility can assist in archiving log files when the database load is high.
D. The
utility is internal to the database and so can impact database activities.
Answer: B
#23. Work is done by Recovery Manager through ___.
A. PL/SQL
packages
B. external procedures
C. operating system scripts
D. operating system commands
Answer: A
#24. When using Recovery Manager without a
catalog, the connection to the target database ___.
A. must be a local connection
B. must be a remote connection
C. can be a local or remote
connection
D. must be specified using a Net8 service name
Answer: C
#25. Which statement about an open database backup is NOT true?
A. The
database must be in ARCHIVELOG mode.
B. The database is available for use during backups.
C. All the database files copied are consistenet to a
point-in-time.
D. An operating system backup of the database files is required.
Answer: C
#26. When performing an open database backup, which
statement is NOT true?
A. The database is fully accessible to all users.
B. The database must be operating in ARCHIVELOG mode.
C. The database
can be open but only in READ ONLY mode.
D. The database tablespaces should be in BEGIN BACKUP mode.
Answer: C
#27. Which command creates a text
backup of the control file?
A. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
B. ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;
C. ALTER DATABASE
BACKUP CONTROLFILE TO 'filename';
D. ALTER DATABASE BACKUP CONTROLFILE TO TEXT 'filename';
Answer: A
#28. When the status of a tablespace
moves from read-only to read-write, which two events occur? (Choose two.)
A. Redo-log switch must take place.
B. Normal checkpoints on the files
now occur.
C. Oracle automatically marks the file for backup.
D. All objects in the tablespace are ckecked for integrity.
E. The DBWn process
writes to the data files of the tablespace.
Answer: B,E
#29. In the view V$DATAFILE_HEADER, what does value "YES" in the "FUZZY" column as
specify?
A. The data file is corrupted.
B. The data file is in backup mode.
C. The data file is locally managed.
D. The data file is part of a
read-only tablespace.
Answer: B
#30. Why would a DBA load a table using the NOLOGGING option?
A. to eliminate further backup
B. to temporarily
disable collecting statistics
C. to reduce redo during a direct-load operation
D. to specify that the blocks retrieved for this table are placed
at the least recently-used end of the buffer
cache
Answer: C

---