单选题You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the data

第1题：

You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）  

• A、 The online redo log file Is not allowed to be overwritten.
• B、 The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
• C、 The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
• D、 The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

第2题：

You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

• A、This operation resets the SCN for the database.
• B、This operation creates a new incarnation of the database.
• C、This operation moves all the redo log files to a different location.
• D、This operation deletes the old redo log files and creates new redo log files.
• E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

第3题：

第4题：

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

• A、 The archived redo log files will be overwritten.
• B、 The archived redo log files are deleted automatically.
• C、 The archived redo log files should be moved to some other location.
• D、 The archived redo log files are still maintained because the file names are unique.

第5题：

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 

• A、to uniquely identify the archived log files with the restore operation
• B、to uniquely identify the archived log files with the redo log group number
• C、to uniquely identify the archived log files for each incarnation of the database
• D、to uniquely identify the archived log files with the number of recovery operations performed

第6题：

Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

• A、recovery cannot be performed because a backup was not performed after the last incomplete recovery
• B、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
• C、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
• D、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

第7题：

The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server：  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files（）

• A、It will be created on the local file system.
• B、It will be created only in the Flash Recovery Area.
• C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
• D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

第8题：

Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）

• A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
• B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
• C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
• D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

第9题：

You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）

• A、 The backup contains data files， the server parameter file，and the control file even if the control file  autobackup is disabled.
• B、 The KEEP option overrides the configured retention policy.
• C、 The backup contains only data files and archived redo log files.
• D、 The KEEP option is an attribute of an individual backup piece.

第10题：

You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）

• A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
• B、They are created only in the Fast Recovery Area.
• C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
• D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.