Oracle
1Z0-050 · Question #24
1Z0-050 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.