单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one.  Which is it?（）A Size of redo logs B Number of datafiles C LOG_CHECKPOINT_INTER

第1题：

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

第2题：

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

• A、Shared pool 
• B、Control file 
• C、SGA 
• D、PGA

第3题：

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

• A、Writes buffers to disk 
• B、Writes current redo log number to datafile headers 
• C、Writes redo log information to disk 
• D、Reads information into memory for users

第4题：

Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）

• A、TARGET_REDO_BLKS
• B、FAST_START_IO_TARGET
• C、LOG_CHECKPOINT_TIMEOUT
• D、RECOVERY_ESTIMATED_IOS
• E、LOG_FILE_SIZE_REDO_BLKS
• F、LOG_CHECKPOINT_INTERVAL

第5题：

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

第6题：

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.

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

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 notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions 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 eachredo log group.

第10题：

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

• A、Database Datafiles 
• B、Database Control Files 
• C、Online redo logs
• D、Archived redo logs 
• E、The database SPFILE 
• F、None of the above, all these files are backed up.