Oracle Database 11g: Administration II

Oracle Database 11g: Administration II

The Oracle Database 11g Administrator II (1Z0-053) exam is primarily intended for Oracle Database 11g administrators, that have a strong foundation and expertise in the industry’s most advanced database management system.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. Prerequisites or additional requirements apply. Please click on the certification link for further clarification. This certification helps their companies qualify for the Oracle Database Specialization.

Exam Number:
1Z0-053
Duration:
120 minutes
Associated Certifications:
Oracle Database 11g Administrator Certified Professional

OPN Certified Specialist
Number of
Questions:
78
Exam Price:
US $195
Pricing may vary slightly by country or by localized currency. Check Pearson VUE’s website for exact pricing in your country.
Passing
Score:
66%

Passing score subject to change. View Details
Click Here to Register:
Register

 

Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy


Recommended Training
Oracle Database 11g Administrator II - Exam Study Guide

OPN Guided Learning Path
Oracle Database 11g Implementation Specialist

Oracle University Training
Oracle Database 11g: Administration Workshop II DBA Release 2

 

 

Additional Information & Resources

Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)
Sample Questions

Practice Exams

The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0

 

 

Exam Topics

Database Architecture and ASM

  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM disk groups

Configuring for Recoverability

  • Configure multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy
  • Configure the Flash Recovery Area
  • Use Flash Recovery Area

Using the RMAN Recovery Catalog

  • Identify situations that require RMAN recovery catalog
  • Create and configure a recovery catalog
  • Synchronize the recovery catalog
  • Create and Use RMAN stored scripts
  • Back up the recovery catalog
  • Create and use a virtual private catalog

Configuring Backup Specifications

  • Configure backup settings
  • Allocate channels to use in backing up
  • Configure backup optimization

Using RMAN to Create Backups

  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup
  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multisection, compressed and encrypted backup
  • Report on and maintain backups

Performing User-Managed Backup and Recovery

  • Recover from a lost TEMP file
  • Recover from a lost redo log group
  • Recover from the loss of password file
  • Perform user-managed complete database recovery
  • Perform user-managed incomplete database recovery
  • Perform user-managed and server managed backups
  • Identify the need of backup mode
  • Back up and recover a control file

Using RMAN to Perform Recovery

  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file
  • Perform Disaster recovery

Using RMAN to Duplicate a Database

  • Creating a duplicate database
  • Using a duplicate database

Performing Tablespace Point-in-Time Recovery

  • Identify the situations that require TSPITR
  • Perform automated TSPITR

Monitoring and Tuning RMAN

  • Monitoring RMAN sessions and jobs
  • Tuning RMAN
  • Configure RMAN for Asynchronous I/O

Using Flashback Technology

  • Restore dropped tables from the recycle bin
  • Perform Flashback Query
  • Use Flashback Transaction

Additional Flashback Operations

  • Perform Flashback Table operations
  • Configure, Monitor Flashback Database and Perform Flashback Database operations
  • Set up and use a Flashback Data Archive

Diagnosing the Database

  • Set up Automatic Diagnostic Repository
  • Using Support Workbench
  • Perform Block Media Recovery

Managing Memory

  • Implement Automatic Memory Management
  • Manually configure SGA parameters
  • Configure automatic PGA memory management

Managing Database Performance

  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload
  • Understand Database Replay

Space Management

  • Manage resumable space allocation
  • Describe the concepts of transportable tablespaces and databases
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources

  • Understand the database resource manager
  • Create and use Database Resource Manager Components

Automating Tasks with the Scheduler

  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Create lightweight jobs
  • Use job chains to perform a series of related tasks

Administering the Scheduler

  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs

 

 

Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
 

 

 E-mail this page  Printer View