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 instan

第1题：

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.

第2题：

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

第3题：

You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

• A、Increase the size of redo log files
• B、Increase the size of redo log buffer
• C、Increase the number of redo log files
• D、Place the redo log files on a separate disk
• E、Decrease the number of redo log groups to two
• F、Increate the number Log Writer （LGWR） process

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

In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

• A、the V$LOG view
• B、the V$DBFILE view
• C、the V$LOGFILE view
• D、the V$INSTANCE_RECOVERY view
• E、Oracle Enterprise Manager Database Control

第6题：

You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）

• A、restore the tablespace from the backup; there is no need to apply the redo information 
• B、restore the full database to recover the data up to the point when you performed the backup 
• C、restore the tablespace from the backup， and then perform a recovery using the backup control file
• D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

第7题：

You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）

• A、 restore the tablespace from the backup； there is no need to apply the redo information
• B、 restore the full database to recover the data up to the point when you performed the backup
• C、 restore the tablespace from the backup and then perform a recovery using the backup control file
• D、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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.

第15题：

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.

第16题：

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

第17题：

You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

• A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
• B、 the column of the V$INSTANCE_RECOVERY view
• C、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
• D、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

第18题：

You work as a database administrator for Certkiller .com. 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 recovers control 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.

第19题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal？（）  

• A、You should recreate the indexes. 
• B、You should compress the log file backups 
• C、You should make the Dworks database use the Full recovery mode 
• D、You should make the Dworks database use the Simple recovery mode.

第20题：

第21题：

第22题：

第23题：