Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-055
Title
: Oracle Database 11g: New
Features for 9i OCPs
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
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?
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.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
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 of RMAN
Answer: D
4. Which are the prerequisites for performing flashback transactions on your database? (Choose all that
apply.)
A. Supplemental log must be enabled.
B. Supplemental log must be enabled for the primary key.
C. Undo retention guarantee for the database must be con