One Of The Leading Certification From Oracle – 1Z0-050

Author: Rhys John

The 1Z0-050 examination is for Oracle Database 11g: New Features for Administrators certification that contains total 77 numbers of queries. The total time allowed to complete the examination is 105 minutes. In order to achieve the examination, candidates need minimum score of 61 percent.

Topics Covered In The Examination:

Installation and Advance Enhancements

  • Utilize online patching
  • Oracle Direct NFS
  • Advance to Oracle Database 11g
  • Install Oracle Database 11g

Storage Enhancements

  • Utilize the ASMCMD extensions, md_backup and md_restore
  • Utilize various new manageability options
  • Setup ASM disk group attributes
  • Get to know performance and scalability enhancements
  • Build ASM fast mirror resynch

Intelligent Infrastructure Enhancements

  • Utilizing new scheduler features
  • Utilizing Database Resource Manager New Features
  • Manage Automated Maintenance Tasks
  • Setting AWR Baseline Metric Thresholds
  • Generating and utilizing AWR baselines

Performance Enhancements

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

Partitioning And Storage-Related Enhancements

  • Generate SQL Access Advisor analysis session by use of PL/SQL
  • SQL Access Advisor Overview
  • Employ Data Compression
  • Execute the new partitioning methods

Using RMAN Enhancements

  • Generate a virtual private catalog for RMAN
  • Handle Recovery Catalogs
  • Execute Archival Backups
  • Back up large files in multiple sections
  • Duplicating a Database
  • Handling Archive logs

Using Flashback And Logminer

  • Working with Logminer
  • Back-out transactions by use of Flashback Transaction
  • Handle Flashback Data Archive
  • Overview of Flashback Data Archive

Diagnosability Enhancements

  • Utilize SQL Repair Advisor
  • Run health checks
  • Utilize Support Workbench
  • Build Automatic Diagnostic Repository

Database Replay

  • Utilizing Workload capture and replay
  • Outline of Workload Capture and Replay

Using The Data Recovery Advisor

  • Execute proactive health test of the database
  • Repairing data failures by use of Data Recovery Advisor
  • Outline of Data Recovery Advisor

Security: New Features

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

Oracle SecureFiles

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

Miscellaneous New Features

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

SQL Performance Analyzer

  • Utilizing SQL Performance Analyzer
  • Overview of SQL Performance Analyzer

SQL Plan Management

  • Build and alter
  • Utilizing SQL Plan Baseline Automatic SQL Tuning
  • Build SQL Plan Baseline
  • SQL Plan Baseline Architecture

Automatic SQL Tuning

  • Interpret reports generated by Automatic SQL Tuning

CertifyGuide is the Best Solution for IT Certification Exams regarding 1Z0-050 PDF and 1Z0-051 eBook.