Oracle认证考试
The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolv
题目
The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:（）
- A、2，4，5
- B、2，1，4，3，5
- C、1，2，3，4，5
- D、1，2，4，5
相似问题和答案
第1题：
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
第2题：
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.
第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题：
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）
- A、The PGA_AGGREGATE_TARGET parameter is set to zero.
- B、The STATISTICS_LEVEL parameter is setto basic.
- C、Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
- D、The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
正确答案:B
第5题：
Automatic data conversion will occur if which of the following happens？（）
- 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
正确答案:B
第6题：
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
第7题：
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？
- A、 database buffer cache
- B、 shared pool
- C、 PGA
- D、 large pool
正确答案:B
第8题：
The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? （）
A. ARCHIVELOG mode must be enabled
B. Row Movement must be enabled for the table
C. FLASHBACK must be set to ON for the database
D. The UNDO_MANAGEMENT parameter must be set to AUTO
E. The UNDO_RETENTION parameter must be set appropriately
第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 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