The following parameters are set for your Oracle 12c database instance:

The following parameters are set for your Oracle 12c database instance_OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou 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_EVOVLE_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.Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94653

Question:

The following parameters are set for your Oracle 12c database instance:

Options:

2, 4, 2005

2, 1, 4, 3, 5

1, 2, 3, 4, 5

1, 2, 4, 5

Correct Answer

The Correct Answer for this Question is

2, 1, 4, 3, 5

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *