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, 4, 5
B.
2, 1, 4, 3, 5
C.
1, 2, 3, 4, 5
D.
1, 2, 4, 5
B.
2, 1, 4, 3, 5
B is correct.
Source: https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94651
Functions in Table 23-5 DBMS_SPM Functions and Procedures for Managing Plan Evolution Tasks are orderd alphabetically mate, not functionally
Correct
the better order would be: 21453 not 21435.
first check the report and then to make a decision whether to implement or not.
B or C?
B