Scroll to top button

1Z0-050 : Oracle Database 11g: New Features for Administrators

Oracle Database 11g: New Features for Administrators
ISBN : 978-1-61691-614-5
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


uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keep the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keep learners engaged and make learning fun.

Here's What You Get

Exercises Flashcards Quizzes

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts.

Exercise 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.


Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
Full Length Tests
Post-Assessments Questions


Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Exam Information

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.

Career Prospects
  • Technical Consultant
  • Database Administrator
  • Data Warehouse Administrator
Exam FAQs
What is the exam registration fee?
USD 245

Pricing and taxes may vary from country to country. Click here for more information on exam pricing.

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?
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.

Table of Content

Here's What you will Learn

Lesson 1: Installation and Upgrade Enhancements

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

Lesson 2: 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

Lesson 3: 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

Lesson 4: Performance Enhancements

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

Lesson 5: 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

Lesson 6: 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

Lesson 7: Using Flashback and Logminer

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

Lesson 8: Diagnosability Enhancements

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

Lesson 9: Database Replay

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

Lesson 10: Using the Data Recovery Advisor

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

Lesson 11: Security: New Features

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

Lesson 12: 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

Lesson 13: 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

Lesson 14: SQL Performance Analyzer

  • Overview of SQL Performance Analyzer
  • Using SQL Performance Analyzer

Lesson 15: SQL Plan Management

  • SQL Plan Baseline Architecture
  • Set up SQL Plan Baseline
  • Using SQL Plan Baseline

Lesson 16: Automatic SQL Tuning

  • Setup and modify Automatic SQL Tuning
  • Interpret reports generated by Automatic SQL Tuning

Copyright © 2002-2017 uCertify / All Rights Reserved.