Oracle Database 11g: New Features for Administrators

Oracle Database 11g: New Features for Administrators

The Oracle Database 11g: New Features for Administrators (1Z0-050) 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. This certification helps their companies qualify for the Oracle Database Specialization. This is an upgrade exam. Certification can only be achieved with this exam if the candidate already holds the 10g DBA OCP.
 

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

OPN Certified Specialist
Number of
Questions:
77
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:
61%

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: New Features for Administrators - Exam Study Guide

OPN Guided Learning Path
Oracle Database 11g Implementation Specialist

Oracle University Training
Oracle Database 11g: New Features for Administrators 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

Installation and Upgrade Enhancements

  • Install Oracle Database 11g
  • Upgrade your database to Oracle Database 11g
  • Oracle Direct NFS
  • Use online patching

Storage Enhancements

  • Setup ASM fast mirror resynch
  • Understand scalability and performance enhancements
  • Setup ASM disk group attributes
  • Use various new manageability options
  • Use the md_backup, md_restore, and ASMCMD extensions

Intelligent Infrastructure Enhancements

  • Creating and using AWR baselines
  • Setting AWR Baseline Metric Thresholds
  • Control Automated Maintenance Tasks
  • Using Database Resource Manager New Features
  • Using new scheduler features

Performance Enhancements

  • ADDM Enhancements
  • Setup Automatic Memory Management
  • Enhancements in statistics collection

Partitioning and Storage-Related Enhancements

  • Implement the new partitioning methods
  • Employ Data Compression
  • SQL Access Advisor Overview
  • Create SQL Access Advisor analysis session using PL/SQL

Using RMAN Enhancements

  • Managing Archive logs
  • Duplicating a Database
  • Back up large files in multiple sections
  • Perform Archival Backups
  • Manage Recovery Catalogs
  • Create a virtual private catalog for RMAN

Using Flashback and Logminer

  • Overview of Flashback Data Archive
  • Manage Flashback Data Archive
  • Back-out transactions using Flashback Transaction
  • Working with Logminer

Diagnosability Enhancements

  • Setup Automatic Diagnostic Repository
  • Use Support Workbench
  • Run health checks
  • Use SQL Repair Advisor

Database Replay

  • Overview of Workload Capture and Replay
  • Using Workload capture and replay

Using the Data Recovery Advisor

  • Overview of Data Recovery Advisor
  • Repairing data failures using Data Recovery Advisor
  • Perform proactive health check of the database

Security: New Features

  • Configure the password file to use case sensitive passwords
  • Encrypt a tablespace
  • Configure fined grained access to network services

Oracle SecureFiles

  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
  • Use SQL and PL/SQL APIs to access Secure File LOBS

Miscellaneous New Features

  • Describe and use the enhanced online table redefinition
  • Enhanced finer grained dependency management
  • Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
  • Use Query Result Cache and PL/SQL Result Cache
  • Adaptive Cursor Sharing
  • Temporary Tablespace Enhancements

SQL Performance Analyzer

  • Overview of SQL Performance Analyzer
  • Using SQL Performance Analyzer

SQL Plan Management

  • SQL Plan Baseline Architecture
  • Set up SQL Plan Baseline
  • Using SQL Plan Baseline Automatic SQL Tuning
  • Setup and modify

Automatic SQL Tuning

  • Interpret reports generated by Automatic SQL Tuning

 

 

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