单选题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 substa

第1题：

In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）

• A、The modified blocks would be written to the data files.
• B、The modified blocks would be written to the temp files.
• C、The modified blocks would be written to the control file.
• D、The modified blocks would be written to the redo log files.
• E、The modified blocks would be written to the archived redo log files.
• F、The modified blocks would be retained in the database buffer cache.

第2题：

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）

• A、 Set DYNAMIC_SAMPLING to level 4
• B、 Set the STATISTICS_LEVEL parameter to BASIC
• C、 Set the INCREMENTAL value to TRUE for the partition table
• D、 Increase the value of STALE_PERCENT for the partition table

第3题：

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.

第4题：

You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

• A、 redo log files
• B、 password file
• C、 control file
• D、 change tracking file

第5题：

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

第6题：

What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）

• A、MTTR Advisor would be disabled.
• B、Redo Log Advisor would be disabled.
• C、Automatic tuning of checkpoint would be disabled.
• D、Checkpoint information would not be written to the alert log file.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）

• A、The database performance would be enhanced.
• B、The redo log files would be get filled more frequently.
• C、The overall database performance would be degraded.
• D、The mean time to recover （MTTR） would be increased.

第14题：

Which two statements are true regarding the database in ARCHIVELOG mode？（）

• A、You have to shut down the database to perform the backups.
• B、Archiving information is written to the data files and redo log files.
• C、You can perform complete database backups without closing the database.
• D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
• E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

第15题：

Which two statements are true about checkpointing（）

• A、The checkpoint frequency decreases with the smaller redo log file size.
• B、It ensures that all committed data is written to the data files during normal shutdown.
• C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.
• D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.

第16题：

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

• A、The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
• B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
• C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
• D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
• E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent

第17题：

You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file：  DB_BLOCK_CHECKING = TRUE；  What will be the result of setting this parameter？（）

• A、 Only data blocks of the SYSTEM tablespace will be checked.
• B、 Only data blocks of the SYSAUX tablespace will be checked.
• C、 A checksum will occur only on the checkpoint.
• D、 A checksum will occur every time a block is modified.

第18题：

You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes.   Which action will you perform to check the data blocks？（）

• A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
• B、 Use the ANALYZE utility.
• C、 Use the DBVERIFY utility.
• D、 Use the DBMS_REPAIR package.

第19题：

第20题：

第21题：

第22题：

第23题：