Where do you find information about a missing redo log file？

第1题：

You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）

• A、 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
• B、 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
• C、 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
• D、 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

第2题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第3题：

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.

第4题：

You received the following error：   ORA-01578： ORACLE data block corrupted   （file # %s， block # %s）   Which file will you check to view additional information regarding the cause of this error？（）

• A、the alert log file and the trace files
• B、 the redo log files
• C、 the control file
• D、 the change tracking file

第5题：

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

第6题：

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

第7题：

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

• A、 The redo log file should belong to an active group.
• B、 The redo log file should belong to an inactive group.
• C、 The redo log file should belong to the current group.
• D、 The redo log file can be dropped only if all the transactions are stopped.
• E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.

第8题：

Where do you find information about a missing redo log file？（）

• A、trace file
• B、audit trail
• C、control file
• D、alert log file
• E、event viewer

第9题：

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）

• A、The backup fails because one of the archived redo log files is missing. 
• B、The backup succeeds but it would be without the missing archived log. 
• C、During backup, you are prompted for the alternative destination for the missing archived redo log file. 
• D、The backup succeeds because it fails over to one of the alternative archived redo log destinations. 

第10题：

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.