Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）A、The SGA advisor will be disabled.B、The MTTR advisor will be disabl

第1题：

检查oracle数据库中下面参数FAST_START_MTTR_TARGET=0LOG_CHECKPOINT_INTERVAL=0这么设置会对数据库有什么影响？（）

• A、检查点信息将不会写到alert文件中
• B、自动检查点调优被关闭
• C、sga advice将被关闭
• D、MTTR advisor将被关闭

第2题：

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

• A、 SQL Tuning Advisor
• B、 Undo Advisor
• C、 ADDM
• D、 Memory Advisor

第3题：

第4题：

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.

第5题：

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）

• A、LOG_BUFFER
• B、SORT_AREA_SIZE
• C、JAVA_POOL_SIZE
• D、STREAMS_POOL_SIZE
• E、DB_16K_CACHE_SZIE
• F、DB_KEEP_CACHE_SIZE

第6题：

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

• A、 The SGA Tuning Advisor
• B、 The SQL Access Advisor
• C、 The SQL Tuning Advisor
• D、 The Memory Advisor

第7题：

Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）

• A、The MTTR advisor will be disabled.
• B、Automatic checkpoint tuning will be enabled.
• C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
• D、The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.

第8题：

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

• A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
• B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
• C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
• D、 Increase the value of the SGA_TARGET initialization parameter.

第9题：

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

• A、 Advisor Central
• B、 Global Attributes
• C、 Resource Monitors
• D、 Memory Parameters
• E、 Database Usage Statistics
• F、 All Initialization Parameters
• G、 Automatic Workload Repository

第10题：

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.  What would be your next step to improve performance？ （）

• A、Run the SQL Access Advisor.
• B、Run the Memory Advisor for the sga.
• C、Run the Memory Advisor for the pga.
• D、Run the Memory Advisor for the shared pool.
• E、Run the Memory Advisor for the buffer cache.