OCA OCP Oracle Certification Exam Braindumps

1.Examine the following PL/SQL block:1z0-055
SET SERVEROUTPUT ON
SET LONG 10000
DECLARE 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?
A. The plan baselines are verified with the SQL profiles.
B. All fixed plan baselines are converted into nonfixed plan baselines.
C. All the nonaccepted SQL profiles are accepted into the plan baseline.
D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
Answer:D

2. View the Exhibit to examine the details for an incident.Which statement is true regarding the status of the incident?

A. The DBA is working on the incident and prefers that the incident be kept in the ADR.
B. The incident is now in the Done state and the ADR can select the incident to be purged.
C. The incident has been newly created and is in the process of collecting diagnostic information.
D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle
Support.
Answer:D