Question 27:
The following parameters 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_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.
Answer options:
A. 2, 4, 5 B. 2, 1, 4, 3, 5 C. 1, 2, 3, 4, 5 D. 1, 2, 4, 5