单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）Aloss of one of the tablespacesBlo

第1题：

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

• A、loss of a tempfile
• B、loss of a system data file
• C、loss of one of the control files
• D、loss of one of the tablespaces
• E、loss of a member from each redo log group
• F、loss of the only member of an unarchived redo log group

第2题：

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）

• A、 Control files
• B、 Password files
• C、 Inactive online redo log file
• D、 Archived log files required to perform recovery
• E、 Newly created tablespace which is not backed up

第3题：

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

• A、 The log sequence is reset to 0.
• B、 All the online redo logs are deleted.
• C、 All the archived redo logs from a previous incarnation become useless.
• D、 The full database backup taken from a previous incarnation can be used in future.
• E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

第4题：

You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

• A、You must shut down the database instance to perform the backups.
• B、You must configure the Flash Recovery Area （FRA） for the database.
• C、You can perform complete database backups without closing the database.
• D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

第5题：

You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

• A、flashback log files
• B、backups that have become obsolete
• C、copies of the data files and control files
• D、archived redo log files that have multiple copies in a different archive location and not backed up

第6题：

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

• A、You find that one of the redo log members in each redo log group is lost.
• B、You find that a data file that belongs to the USERS tablespace is damaged.
• C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
• D、You find that the current redo log group is damaged and is not available for recovery.
• E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

第7题：

You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

• A、 loss of one of the tablespaces
• B、 loss of a system data file
• C、 loss of one of the control files
• D、 loss of a tempfile
• E、 loss of the only member of an unarchived redo log group
• F、 loss of a member from each redo log group

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

• A、 open the database with the RESTRICTED option
• B、 open the database with the RESETLOGS option
• C、 recover to the required SCN only that data file in which the error occurred
• D、 recover all the data files to the same system change number （SCN）

第14题：

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.

第15题：

In which two cases would you perform only consistent backup？（）

• A、You are working on a database where downtime is not tolerated.
• B、You are working on a database where downtime can be tolerated.
• C、You are working on a database that operates in ARCHIVELOG mode.
• D、You are working on a database that operates in NOARCHIVELOG mode.
• E、You are working on a database where all the tablespaces are locally managed.
• F、You are working on a database where control files and redo log files are multiplexed.
• G、You are working on a database where control files and redo log files are not multiplexed.

第16题：

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

• A、Open the database in NORMAL mode
• B、Open the database in read-only mode
• C、Open the database in RESTRICTED mode
• D、Open the database with the RESETLOGS option

第17题：

Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

• A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
• B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
• C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
• D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

第18题：

The loss of which two types of files may require a recovery with the RESETLOGS option？（）

• A、 control files
• B、 password file
• C、 archived log files
• D、 system-critical data files for which all the redo entries are present
• E、 non-system-critical data files for which all the redo entries are present

第19题：

第20题：

第21题：

第22题：

第23题：