最近网上打听oracle认证考试的比较多i,可能考友们会利用业余时间来考试的。这里,我就简单地和大家分享一下,我所知道的部分考试资料,下面的几道题目也是我精心整理出来的,虽然题目不是太多,也不是太全,但是至少对一部分考生还是比较有帮助的。
考试号:1Z0-055
认证名称:Oracle Database 11g: New Features for 9i OCPs
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 baselines.
C. All the nonaccepted SQL profiles are accepted into the plan baseline.
D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
Answer: D