nerdexam
Oracle

1Z0-063 · Question #106

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…

The correct answer is B. 2, 1, 4, 3, 5. See the full explanation below for the reasoning.

Question

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) Setthe 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.

Options

  • A2, 4, 5
  • B2, 1, 4, 3, 5
  • C1, 2, 3, 4, 5
  • D1, 2, 4, 5

How the community answered

(63 responses)
  • A
    3% (2)
  • B
    79% (50)
  • C
    6% (4)
  • D
    11% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice