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，5B、2，1，4，3，5C、1，2，3，4，5D、1，2，4，5
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
相关考题：
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?() A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
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 enabledB. Row Movement must be enabled for the tableC. FLASHBACK must be set to ON for the databaseD. The UNDO_MANAGEMENT parameter must be set to AUTOE. The UNDO_RETENTION parameter must be set appropriately
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 PERMITTEDB. Set the DB_ULTRA_SAFE parameter to DATA_ONLYC. Set the DB_LOCK_CHECKSUM parameter to TYPICALD. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?() A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
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.
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ 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 cacheB、 shared poolC、 PGAD、 large pool
Automatic data conversion will occur if which of the following happens？（）A、 The client and server have different NLS_LANGUAGE settingsB、 The client and server character sets are not the same，and the database character set is not a strict superset of the client character setC、 The client and server are in different time zonesD、 The client requests automatic data conversionE、 The AUTO_CONVERT initialization parameter is set to TRUE
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 setB、 The SQL_TRACE parameter is set to FALSEC、 The Enterprise Manager Grid Control is not usedD、 The STATISTICS_LEVEL parameter is set to BASICE、 The TIMED_STATISTICS parameter is set to FALSE
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.
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 FALSEC、The Enterprise Manager Grid Control is not used.D、The STATISTICS_LEVEL parameter is set to BASICE、The TIMED_STATISTICS parameter is set to FALSE
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.
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A、 Set MEMORY_TARGET to zeroB、 Set the STATISTICS_LEVEL parameter to BASICC、 Set the WORKAREA_SIZE_POLICY parameter to MANUALD、 Set the PGA_AGGREGATE_TARGET parameter to nonzero value
You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）A、ALLB、PFILEC、BOTHD、NONEE、SPFILEF、MEMORYG、INSTANCEH、DATABASE
You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A、 only the INSTANCE_TYPE initialization parameter is set to an invalid valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
多选题You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCEHDATABASE
单选题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？（）AThe EVENT parameter was not set.BThe SQL_TRACE parameter is set to FALSECThe Enterprise Manager Grid Control is not used.DThe STATISTICS_LEVEL parameter is set to BASICEThe TIMED_STATISTICS parameter is set to FALSE
单选题In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）AThe STATISTICS_LEVEL initialization parameter is set to BASICBThe PGA_AGGREGATE_TARGET initialization parameter is set to zero.CThe SGA_MAX_SIZE initialization parameter is set to less than 20 GBDThe DB_CACHE_SIZE initialization parameter is set to less than 5 GBEThe SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
多选题The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE） WHERE ename = ’ALLEN’； What are the minimum requirements for the statement to execute successfully？（）AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately
单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）AThe STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.BThe STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.CThe STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.DNothing happens; because there is no SPFILE for each PDB, the statement is ignored.
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value
单选题You have included the following parameter settings in your SPFILE:// SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）AThe SGA_TARGET initialization parameter cannot be set to a value greater than 8GB The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2GC The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2GD The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M E The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
单选题You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A only the INSTANCE_TYPE initialization parameter is set to an invalid valueB only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
单选题You have the following requirements in relation to the detection of block corruption for your database instance： Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. 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 PERMITTEDB Set the DB_ULTRA_SAFE parameter to DATA_ONLYC Set the DB_LOCK_CHECKSUM parameter to TYPICALD Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
多选题You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）AThe MEMORY_MAX_TARGET parameter is automatically set to 500 mb.BThe pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.CThe value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.DThe lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively
单选题You have created a password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3 Which of the following is true about this password file？（）A If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.B If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.C If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file isD If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.
单选题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.（）AThe PGA_AGGREGATE_TARGET parameter is set to zero.BThe STATISTICS_LEVEL parameter is setto basic.CBoth the SGA_TARGETandMEMORY_TARGET paramete rsareset.DThe SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
单选题Automatic data conversion will occur if which of the following happens?（）AThe client and server have different NLS_LANGUAGE settings.BThe client and server character sets are not the same, and the database character set is not a strict superset of the client character set.CThe client and server are in different time zones.DThe client requests automatic data conversion.EThe AUTO_CONVERT initialization parameter is set to TRUE.