19 07 2014
QUESTION 1 Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000 DECLARE 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 plan baselines are verified with the SQL profiles. B. All fixed plan baselines are converted into nonfixed plan […]