цена: 13000 руб.
Для юридических лиц: 13000 руб.

Чтобы забронировать место авторизуйтесь на сайте или пройдите регистрацию.

Oracle Database 11g: New Features for Administrators



Oracle
Код: 1Z0-050
продолжительность: 105 минут
Язык обучения: English
Тестовая система: Pearson VUE
Филиал: Москва

Содержание

Exam Topics:

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

SQL Performance Analyzer

  • Overview of SQL Performance Analyzer
  • Using SQL Performance Analyzer

SQL Plan Management

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

Automatic SQL Tuning

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


Оставить отзыв
Об этом экзамене отзывов пока нет. Будьте первым.