1Z0-055 : Oracle Database 11g: New Features for 9i OCPs

Retired. This product is no longer available.

The 1Z0-055 exam is an upgrade exam for existing Oracle DBAs that hold a 9i DBA OCP certification and want to upgrade to Oracle Database 11g Administrative Certified Professional certification. The exam has been validated against Oracle's Database 11g Release 2 version
49 49
Oracle Database 11g: New Features for 9i OCPs

Here's what you will get

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role.

Pre-assessment Questions
Full Length Tests
Post-Assessment Questions
Exam FAQs
What is the exam registration fee? USD 245
Where do I take the exam? The 1Z0-055 exam is administered by Pearson VUE at testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam? The exam consists of scenario-based multiple choice questions.
What are the pre-requisites of the exam? This is an upgrade exam and requires professionals to have Oracle9i Database Administrator Certified Professional certification prior to the 1Z0-055 exam.
How many questions are asked in the exam? The exam contains 84 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 61%
What is the exam's retake policy?

Retake Policy for Oracle 1Z0-061 exam is:

  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may not retake a beta exam at any time.
What is the validity of the certification? The Oracle Database 11g: New Features for 9i OCPs Certified Expert certification has no expiration. The certification holder is certified for life unless Oracle changes their policy. Click here for more information.
Where can I find more information about this exam? To know more about the 1Z0-055, click here.
What are the career opportunities after passing this exam?
  • Database Administrators
  • Data Warehouse Administrator
  • Technical Consultant

Here's what you will learn

  • Install Oracle Database 11g
  • Upgrade your database to Oracle Database 11g
  • Use online patching
  • Create and maintain bigfile tablespaces
  • Rename tablespaces
  • Create a default permanent tablespace
  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Execute SQL commands with ASM file names
  • Use ASMCMD Command-Line Interface
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • Setup ASM fast mirror resynch
  • Understand scalability and performance enhancements
  • Using SQL Performance Analyzer
  • SQL Plan Baseline Architecture
  • Set up SQL Plan Baseline
  • Using SQL Plan Baseline
  • Overview of Workload Capture and Replay
  • Using Workload capture and replay
  • Describe and use the enhanced online table redefinition
  • Use fine-grained auditing for DML statements
  • Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
  • Use Query Result Cache and PL/SQL Result Cache
  • Create temporary tablespace groups
  • Assign temporary tablespace groups to users
  • Temporary Tablespace Enhancements
  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
  • Use SQL and PL/SQL APIs to access Secure File LOBS
  • Use the SQL Tuning Advisor
  • SQL Access Advisor Overview
  • Create SQL Access Advisor analysis session using PL/SQL
  • Setup and modify Automatic SQL Tuning
  • Interpret reports generated by Automatic SQL Tuning
  • Use SQL Repair Advisor
  • Monitor and maintain the AWR
  • Creating and using AWR baselines
  • Control Automated Maintenance Tasks
  • Using Database Resource Manager New Features
  • Simplify management tasks by using the Scheduler
  • Create a job, program, schedule and window
  • View information about job executions and job instances
  • Monitor and manage server-generated alerts
  • Use Automatic Database Diagnostic Monitor (ADDM)
  • ADDM Enhancements in 11g
  • Use Automatic Shared Memory Management
  • Setup Automatic Memory Management
  • Enhancements in statistics collection
  • Reduce space related error conditions through proactively managing tablespace usage
  • Reclaim wasted space from tables and indexes using the segment shrink functionality
  • Use the Segment Advisor
  • Use the Undo Advisor
  • Use Automatic Undo Retention Tuning
  • Implement the new partitioning methods
  • Employ Data Compression
  • Transport tablespaces across different platforms
  • Explain Data Pump architecture
  • Monitor a Data Pump job
  • Use Data Pump export and import
  • Create external tables for data population
  • Simplify file management for all recovery-related file
  • Reduce restore time by applying incremental backups to data file image copies
  • Simplify recovery after opening the database with the RESETLOGS option
  • Speed backup times by creating faster incremental backups
  • Minimize load requirements by specifying limits in backup time windows
  • Save storage space through writing compressed backup sets
  • Managing Archive logs
  • Configure and use Flashback Database
  • Recover dropped tables with the Flashback Drop feature
  • Retrieve row history information with the Flashback Versions Query feature
  • Audit or recover FROM transactions with the Flashback Transaction Query feature
  • Recover tables to a point in time with the Flashback Table feature
  • Back-out transactions using Flashback Transaction
  • Setup Automatic Diagnostic Repository
  • Use Support Workbench
  • Run health checks
  • Overview of Data Recovery Advisor
  • Repairing data failures using Data Recovery Advisor
  • Perform proactive health check of the database
  • Configure the password file to use case sensitive passwords
  • Encrypt a tablespace
  • Configure fined grained access to network services