单选题You can control instance recover performance by setting parameters to define targets for（）A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins

第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题：

You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

• A、to enable the ASM instance to identify the alert log file
• B、to enable the ASM instance to identify the server parameter file
• C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
• D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

第3题：

Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）

• A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
• B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
• C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
• D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

第4题：

Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）

• A、Data blocks have to be written more frequently by DBWR. 
• B、Redo blocks have to be written more frequently by LGWR. 
• C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. 
• D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

第5题：

What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）

• A、It can contain parameters with distinct values for each distance.
• B、It can contain only parameters with identical values for each instance.
• C、It must contain an IFILE parameter for each instance’s individual parameter file.
• D、It must be located in the default location for the primary instance’s parameter file.

第6题：

Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the  Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost.  Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database.  What are three other characteristics of Trial Recovery（）

• A、Speeds up subsequent media recover actions.
• B、Writes any uncorrupted block to disk during the test recovery.
• C、Can be invoked by adding the TEST option to any RECOVER command.
• D、Allows the Administrator to determine how many blocks are affected by corruption.
• E、Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.

第7题：

Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）

• A、 increase the number of checkpoint processes
• B、 define the POWER option while adding or removing the disks
• C、 increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
• D、 increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
• E、 increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

第8题：

You can control instance recover performance by setting parameters to define targets for（）

• A、The size of the redo buffer in SGA. 
• B、The instance that will perform recovery in Real Application Cluster database. 
• C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 
• D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

第9题：

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

• A、Start the instance and open the database， instance recovery automatically recoverscontrol files
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
• C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
• D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
• E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

第10题：

You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）

• A、By multiplexing the control files
• B、By multiplexing the redo log files
• C、By decreasing the size of redo log files
• D、By configuring mean time to recover （MTTR） to a lower value
• E、By setting the UNDO_RETENTION parameter to a higher value