单选题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:()A2,4,5B2,1,4,3,5C1,2,3,4,5D1,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 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

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_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

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 startupORA-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.

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

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_SIZEB、 The database instance starts,and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGAC、 The database instance starts,but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

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.

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.  What would you do with these SQL statements?()A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B、 Capture the plans from the previous version using STS and then load them into the stored outline.C、 Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB)D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

Your tnsnames.ora file has the following entry for the service alias ORCL:  ORCL =  (DESCRIPTION =  (ADDRESS = (PROTOCOL = TCP) (HOST = 10.156.24.216) (PORT = 1521))   (CONNECT_DATA =  (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle.com)   )   )   The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command:  SQL CONNECT scott/tiger@orcl  What could be the reason for this?()A、The listener is not running at the server.B、The TNS_ADMIN environmental variable is set to a wrong value.C、The orcl.oracle.com database service is not registered with the listener.D、The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.

You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order: 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task()A、4, 1, 3, 2, 5B、1, 3, 4, 5, 2C、1, 3, 2, 5; 4 not requiredD、4, 1, 5, 2; 3 not requiredE、1, 3, 4, 5; 2 not required

You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:  1:Shut down the instance.  2:Execute the ALTER DATABASE ARCHIVELOG command.  3:Start up the instance and mount the database.  4:Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5: Open the database.  Which is the correct sequence of steps for accomplishing the task()A、4,1,3,2,5B、1,3,4,5,2C、1,3,2,5;4 not requiredD、4,1,5,2;3 not requiredE、1,3,4,5;2 not required

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps would you perform to achieve this?()A、Set the UNDO_RETENTION parameter to 900 or more.B、Create an initial undo segment in the undo tablespace.C、Enable the retention guarantee for the undo tablespace.D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

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 are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()A the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB the column of the V$INSTANCE_RECOVERY viewC the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

单选题You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order: 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task()A4, 1, 3, 2, 5B1, 3, 4, 5, 2C1, 3, 2, 5; 4 not requiredD4, 1, 5, 2; 3 not requiredE1, 3, 4, 5; 2 not required

单选题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:()A2,4,5B2,1,4,3,5C1,2,3,4,5D1,2,4,5

单选题You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order: 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task()A4, 1, 3, 2, 5B1, 3, 4, 5, 2C1, 3, 2, 5; 4 not requiredD4, 1, 5, 2; 3 not requiredE1, 3, 4, 5; 2 not required

单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?()ASet OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.BCapture the plans from the previous version using STS and then load them into the stored outline.CCapture the plans from the previous version using STS and then load them into SQL Management Base (SMB).DSet OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

单选题You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()Ato minimize plan regression due to the use of a new optimizer versionBto completely avoid the use of new plans generated by a new optimizer versionCto prevent plan capturing when the SQL statement is executed after the database upgradeDto keep the plan in the plan history so that it can be used when the older version of the optimizer is used

单选题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 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?()AThe database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEBThe database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGACThe database instance starts, but Automatic Memory Management is disabledDThe database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

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

单选题You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:  1:Shut down the instance.  2:Execute the ALTER DATABASE ARCHIVELOG command.  3:Start up the instance and mount the database.  4:Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5: Open the database.  Which is the correct sequence of steps for accomplishing the task()A4,1,3,2,5B1,3,4,5,2C1,3,2,5;4 not requiredD4,1,5,2;3 not requiredE1,3,4,5;2 not required

单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()AWhen you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.BWhen a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.CWhen a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.DWhen you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.  What would you do with these SQL statements?()A Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B Capture the plans from the previous version using STS and then load them into the stored outline.C Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB)D Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

单选题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:()A2,4,5B2,1,4,3,5C1,2,3,4,5D1,2,4,5