Zertifizierungsprüfung 1Z0-055 Oracle

Die hervorragenden Punkte in der Zertifizierungsprüfung werden von zertifizierung-portal.de deutlich zeigen.Und Sie können ein gründliches Verständnis für Ihrer IT-Prüfung erhalten.

1Z0-055 Oracle Database 11g: New Features for 9i OCPs ACE Acrobat, ACE AfterEffects, ACE Captivate, ACE ColdFusion
,ACE Dreamweaver,ACE Flash, ACE Flex, ACE FrameMaker,ACE GoLive,ACE Illustrator,ACE InDesign,ACE LiveCycle,ACE Premiere,ACE RoboHelp, Adobe Certification, Photoshop,Photoshop Certified Expert

Zertifizierungsprüfung 1Z0-055 Oracle

QUESTION 1
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?

A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

Answer: C

QUESTION 2
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

Answer: CE

QUESTION 3
Which statement about the enabling of table compression in Oracle Database 11g is true?

A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
B. Compression can be enabled only at the table level for both direct loads and conventional DML.
C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and
conventional DML.

Answer: D

Zertifizierungsprüfung 1Z0-055 Oracle