CMS专题

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

题目
单选题
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题：

The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?()

A. The Oracle database will perform block checking for the index blocks only

B. The Oracle database will not perform block checking for any of the data blocks

C. The Oracle database will perform block checking for the default permanent tablespace only

D. The Oracle database will perform block checking for the data blocks in all user tablespaces

E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only


参考答案：E

第2题：

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? （）

  • A、Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
  • B、Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
  • C、Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
  • D、Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

正确答案:A,D

第3题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()

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


参考答案：D

第4题：

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  • A、The Oracle kernel will be placed in this location.
  • B、The Oracle software will be placed in this location.
  • C、The server parameter file （SPFILE） will be placed in this location.
  • D、The database files will be placed in this location， if not specified explicitly.
  • E、The location will be considered for the base of Oracle Managed Files （OMF）.
  • F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.

正确答案:F

第5题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

  • A、 The database will not start.
  • B、 The database will start but will not retain the undo data in the undo segment.
  • C、 The database will start， and the undo segment will contain the undo data for at least one hour.
  • D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

正确答案:D

第6题：

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

第7题：

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.

正确答案:B

第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


参考答案：B

第9题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

  • A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
  • B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
  • C、 The database instance starts，but Automatic Memory Management is disabled
  • D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

正确答案:B

第10题：

The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

  • A、 The Oracle database will perform block checking for the index blocks only
  • B、 The Oracle database will not perform block checking for any of the data blocks
  • C、 The Oracle database will perform block checking for the default permanent tablespace only
  • D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
  • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

正确答案:E

更多相关问题
相关内容