Oracle Exam 1Z0-060 Topic 5 Question 50 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 50
Topic #: 5

[All 1Z0-060 Questions]

The following parameters 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:

A2, 4, 5

B2, 1, 4, 3, 5

C1, 2, 3, 4, 5

D1, 2, 4, 5

Show Suggested Answer

Suggested Answer: C, D, E

by Justine at Nov 21, 2022, 04:24 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!