Oracle
1Z0-050 · Question #49
1Z0-050 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
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.
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.