#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
[1] [2] [3] [4] [5] 下一页