Identify the correct sequence of steps:

The following parameter are set for your Oracle 12c database instance: 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:

The following parameter are set for your Oracle 12c database instance: 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, 1, 4, 3, 5

B.
1, 2, 3, 4, 5

C.
1, 2, 4, 5

D.
2, 4, 5

Explanation:



Leave a Reply 2

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