READ Free Dumps For Oracle- 1z0-050
Question ID 5943 | Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000 ECLARE 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? |
Option A | The plan baselines are verified with the SQL profiles. |
Option B | All fixed plan baselines are converted into nonfixed plan baselines. |
Option C | All the nonaccepted SQL profiles are accepted into the plan baseline. |
Option D | The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines. |
Correct Answer | D |
Question ID 5944 | In which two aspects does hot patching differ from conventional patching? (Choose two.) |
Option A | It consumes more memory compared with conventional patching |
Option B | It can be installed and uninstalled via OPatch unlike conventional patching. |
Option C | It takes more time to install or uninstall compared with conventional patching. |
Option D | It is not persistent across instance startup and shutdown unlike conventional patching. |
Option E | It is not persistent across instance startup and shutdown unlike conventional patching. |
Correct Answer | A,D |