CMS专题
多选题The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）AThe optimi
题目
The optimizer adds the new plan to the plan history.
The optimizer selects the new plan for the execution of the SQL statement.
The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
相似问题和答案
第1题：
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
第2题：
A.120M
B.320M
C.480M
D.600M
第3题：
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第4题：
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）
- A、The EVENT parameter was not set.
- B、The SQL_TRACE parameter is set to FALSE
- C、The Enterprise Manager Grid Control is not used.
- D、The STATISTICS_LEVEL parameter is set to BASIC
- E、The TIMED_STATISTICS parameter is set to FALSE
正确答案:D
第5题：
Which three statements correctly describe the features of the I/O calibration process?（）
- A、Only one I/O calibration process can run at a time.
- B、It automates the resource allocation for the Automated Maintenance Tasks.
- C、It improves the performance of the performance-critical sessions while running.
- D、It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
- E、The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
正确答案:A,D,E
第6题：
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario?（）
A. The optimizer adds the new plan to the plan history.
B. The optimizer selects the new plan for the execution of the SQL statement.
C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
第7题：
A. The client and server have different NLS_LANGUAGE settings.
B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
C. The client and server are in different time zones.
D. The client requests automatic data conversion.
E. The AUTO_CONVERT initialization parameter is set to TRUE.
第8题：
You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? （）
A. Set the DB_SECUREFILE parameter to PERMITTED
B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY
C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL
D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
第9题：
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）
- A、 The EVENT parameter was not set
- B、 The SQL_TRACE parameter is set to FALSE
- C、 The Enterprise Manager Grid Control is not used
- D、 The STATISTICS_LEVEL parameter is set to BASIC
- E、 The TIMED_STATISTICS parameter is set to FALSE
正确答案:D
第10题：
You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）
- A、The advisory memory has been turned off.
- B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
- C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
- D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
- E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
正确答案:C