Scroll to top button

Oracle Database 11g: New Features for Administrators

ISBN : 9781616916145

Gain hands-on expertise in Oracle Database 1Z0-050 certification exam with Oracle Database 11g: New Features for Administrators course. The course covers all the objectives of the 1Z0-050 exam which include benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and much more. The 1Z0-050 exam has been validated against Oracle's Database 11g Release 2 version

The Oracle Database 11g: New Features for Administrators exam is a standalone certification from Oracle with the exam code 1Z0-050. The 1Z0-050 exam is an upgrade exam for current Oracle 10g DBAs that hold a 10g DBA OCP certification and want to upgrade to the Oracle Database 11g Administrator Certified Professional certification.

Database 11g: New Features for Administrators exam is also part of the Oracle Partner Network (OPN) set of specialized certifications. OPN Members earning this certification will be recognized as OPN Certified Specialists.

Pre Assessment Questions
Post Assessment Questions

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam related FAQs
What is the exam registration fee? USD 245
Where do I take the exam? The 1Z0-050 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? Oracle has the following pre-requisites for Database 11g: New Features for Administrators certification: This is an upgrade exam from 10g to 11g; Oracle requires professionals to have Oracle 10g DBA OCP certification prior to the 1Z0-050 exam.
How many questions are asked in the exam? The exam contains 77 questions.
What is the duration of the exam? 105 minutes
What is the passing score? 61%
What is the exam's retake policy?

Retake Policy for Oracle 1Z0-051 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 Administrator Certified Associate 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-050, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Technical Consultant
  • Database Administrator
  • Data Warehouse Administrator
  • Install Oracle Database 11g
  • Upgrade your database to Oracle Database 11g
  • Oracle Direct NFS
  • Use online patching
  • 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
  • Creating and using AWR baselines
  • Setting AWR Baseline Metric Thresholds
  • Control Automated Maintenance Tasks
  • Using Database Resource Manager New Features
  • Using new scheduler features
  • ADDM Enhancements
  • Setup Automatic Memory Management
  • Enhancements in statistics collection
  • Implement the new partitioning methods
  • Employ Data Compression
  • SQL Access Advisor Overview
  • Create SQL Access Advisor analysis session using PL/SQL
  • 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
  • Overview of Flashback Data Archive
  • Manage Flashback Data Archive
  • Back-out transactions using Flashback Transaction
  • Working with LogMiner
  • Setup Automatic Diagnostic Repository
  • Use Support Workbench
  • Run health checks
  • Use SQL Repair Advisor
  • Overview of Workload Capture and Replay
  • Using Workload capture and replay
  • 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
  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
  • Use SQL and PL/SQL APIs to access Secure File LOBS
  • 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
  • Overview of SQL Performance Analyzer
  • Using SQL Performance Analyzer
  • SQL Plan Baseline Architecture
  • Set up SQL Plan Baseline
  • Using SQL Plan Baseline
  • Setup and modify Automatic SQL Tuning
  • Interpret reports generated by Automatic SQL Tuning