Oracle
1Z0-050 · Question #49
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…
The correct answer is B. It is loaded with the ACCEPTED status. See the full explanation below for the reasoning.
Question
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?
Options
- AIt is loaded with the FIXED status.
- BIt is loaded with the ACCEPTED status.
- CIt is not loaded with the ENABLED status.
- DIt is not loaded with the ACCEPTED status.
How the community answered
(38 responses)- A5% (2)
- B71% (27)
- C8% (3)
- D16% (6)
Community Discussion
No community discussion yet for this question.