Oracle
1Z0-050 · Question #24
Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report); END; Which statement…
The correct answer is D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines. See the full explanation below for the reasoning.
Question
Examine the following PL/SQL block:
SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report); END; Which statement describes the effect of the execution of the above PL/SQL block?
Options
- AThe plan baselines are verified with the SQL profiles.
- BAll fixed plan baselines are converted into nonfixed plan baselines.
- CAll the nonaccepted SQL profiles are accepted into the plan baseline.
- DThe nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
How the community answered
(41 responses)- A2% (1)
- B7% (3)
- C5% (2)
- D85% (35)
Community Discussion
No community discussion yet for this question.