单选题As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）A Cancel-basedB Recovery using a back

第1题：

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）  

• A、 You should perform a log switch
• B、 You should make a backup of the database
• C、 You should switch the database to the NONARCHIVELOG mode
• D、 You should shut down the database instance and perform a complete database recovery

第2题：

A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.  

• A、 1，3，4，and 5
• B、 7，3，4. and 5
• C、 2，3，4，and 5
• D、 7，4，3，and 5
• E、 Only 6 is required

第3题：

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.

第4题：

As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）

• A、Cancel-based
• B、Recovery using a backup control file
• C、Time-based
• D、Change-based

第5题：

In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

• A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
• B、 when all the online redo log groups are not multiplexed and one log group is missing
• C、 when all the control files are missing
• D、 when some important tables are deleted from the database and purged from the Recycle Bin

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

• A、 import the database from the last export
• B、 restore all the members in the group from the last backup
• C、 drop the lost member from the database and then add a new member to the group
• D、 restore all the database files from the backup and then perform a complete recovery
• E、 restore all the database files from the backup and then perform an incomplete recovery

第14题：

Which statement about recovering from the loss of a redo log group is true?（）

• A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
• B、If the lost redo log group is CURRENT, you must clear the log file.
• C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
• D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

第15题：

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.

第16题：

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

• A、import the database from the last export
• B、restore all the members in the group from the last backup
• C、drop the lost member from the database， and then add a new member to the group
• D、restore all the database files from the backup， and then perform a complete recovery 
• E、restore all the database files from the backup， and then perform an incomplete recovery

第17题：

Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors：   ORA-00313： open failed for members of log group 1 of thread 1   ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue？（）

• A、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；
• B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；
• C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；
• D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：