One of the redo log members in your database is lost. You qu

第1题：

In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）

• A、increase the size of the redo log buffer
• B、increase the number of redo log groups
• C、increase the number of log writer processes
• D、increase the number of ARCn processes
• E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

第2题：

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  

• A、the value of the UNDO_RETENTION initialization parameter
• B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
• C、the online redo log files size
• D、the number of redo log members in a group

第3题：

第4题：

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

• A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
• B、 Before the instance starts， you receive an error about the missing redo log files of a group.
• C、 The instance starts and the database opens with an error message written to the alert log file.
• D、 The instance starts and the database opens because two redo log groups still exist.
• E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

第5题：

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’

第6题：

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

第7题：

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）

• A、Disable automatic checkpoint tuning.
• B、Check the size of the redo log file size and increase the size if it is small.
• C、Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. 
• D、Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

第8题：

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.

第9题：

One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

• A、LOST
• B、INVALID
• C、EXPIRED
• D、DELETED
• E、CORRUPT
• F、UNKNOWN
• G、OBSOLETE

第10题：

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