Which statement describes the effect of the execution of the above PL/SQL block?

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?

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?

A.
The nonaccepted plans in the SQL Management Base are verified with the existing plan
baselines.

B.
All the nonaccepted SQL profiles are accepted into the plan baseline.

C.
The plan baselines are verified with the SQL profiles.

D.
All fixed plan baselines are converted into nonfixed plan baselines.



Leave a Reply 1

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


Google

Google

Wonderful story, reckoned we could combine a number of unrelated information, nevertheless really really worth taking a look, whoa did a single find out about Mid East has got additional problerms also.