Create Account

Oracle 1Z0-050

Oracle Database 11g: New Features for Administrators

Free Questions in OTE format

File Date Q&A Votes Size 2016-09-28 187 0/0 2.31 Mb 2016-04-13 183 0/0 2.29 Mb 2014-07-17 183 0/0 2.30 Mb

Notification about new Oracle 1Z0-050 files

Subscribe to Oracle 1Z0-050 dump here, you will be informed about new OTE files.

About Oracle 1Z0-050 dump

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

© 2006 ExamBrainDumps