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

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.

Lessons
Lessons
16+
Exercises
291+
Quizzes
102+
TestPrep
Pre Assessment Questions
15+
Full Length Tests
4+
Post Assessment Questions
70+

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
Videos
1+
  • 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
×