Itrenzheng 最新 Oracle OCP 1Z0-055认证题库.Image.Marked.pdfVIP

The safer , easier way to help you pass any IT exams. Exam : 1Z0-055 Title : Oracle Database 11g: New Features for 9i OCPs Version : DEMO 1 / 11 The safer , easier way to help you pass any IT exams. 1. Examine the following PL/SQL block: 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? 2 / 11 The safer , easier way to help you pass any IT exams. 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 3. You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task? A. Data Pump Export and Import B. conventional export and import C. the CONVERT command of RMAN D. the BACKUP AS COPY.. command o