The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof 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 UN

第1题：

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、ALTER DATABASE DROP LOGFILE GROUP 1;
• B、ALTER DATABASE CLEAR LOGFILE GROUP 1;
• C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
• D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG

第2题：

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

第3题：

第4题：

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

第5题：

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

• A、ALTER DATABASE 
• B、ALTER SYSTEM 
• C、ALTER USER 
• D、ALTER REDO LOG

第6题：

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

• A、SMON would automatically restore the lost file.
• B、You would need to restore the whole database from the last backup.
• C、You would need to restore the file from the last full database backup.
• D、You would need to use flashback technology to restore the lost redo log member.
• E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
• F、You would need to restore the missing log file by copying one of the remaining files from the same group.

第7题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

• A、archival
• B、log writer
• C、database writer
• D、system monitor
• E、process monitor
• F、change tracking writer

第8题：

第9题：

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：（）

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

第10题：

A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）

• A、 clear the redo log group
• B、 perform redo log file import
• C、 perform an incomplete recovery
• D、 perform a redo log recovery using Recovery Manager （RMAN）
• E、 shut down the database and open the database in the NOARCHIVELOG mode