Oracle 1z0-055 : Oracle Database 11g: New Features for 9i OCPs Exam
The Oracle 1z0-055: Oracle Database 11g: New Features for 9i OCPs exam addresses issues of certification for Oracle Database 11g Administrator Certified Professional and OPN Certified Specialist. The exam contains 84 individual items and participants are given 120 minutes in which to complete them. A passing score of 61% must be achieved in order to qualify for certification. However, the exact percentage is subject to change.
Exam topics include, but are not limited to, the following:
1. Installation and Upgrade Enhancements - Exam participants are required to install Oracle Database 11g and to employ upgrades using online patching.
2. SQL Tuning - Participants must use the SQL Tuning Advisor, SQL Access Advisor Overview and create SQL Access Advisor analysis session using PL/SQL. They must set up and modify Automatic SQL Tuning and interpret reports that have been generated by Automatic SQL Tuning. They must also use SQL Repair Advisor.
3. Storage Enhancements - Exam participants must be proficient at creating and maintaining bigfile tablespaces. They are required to create a default permanent tablespace and to describe Automatic Storage Management (ASM). Additionally, they should know how to set up initialization parameter files for AS and database instances and to execute SQL commands with ASM file names.