Oracle 11G OCP 1Z0-053 226

LuiseDalian發表於2014-09-05
Oracle
（226）Examine the following PL/SQL block:

DECLARE

  my_plans pls_integer;

BEGIN

  my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id => '9twu5t2dn5xd');

END;

Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

A. It is loaded with the FIXED status.

B. It is loaded with the ACCEPTED status.

C. It is not loaded with the ENABLED status.

D. It is not loaded with the ACCEPTED status.

答案：（B）

解析：

DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id IN VARCHAR2,

                                      plan_hash_value IN NUMBER:=NULL,

                                      sql_text IN CLOB,

                                      fixed IN VARCHAR2:='NO',

                                      enabled IN VARCHAR2:='YES') RETURN PLS_INTEGER;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1264805/，如需轉載，請註明出處，否則將追究法律責任。

相關文章