（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博客

Oracle 11G OCP 1Z0-053 226