Oracle Database 11g: New Features for 9i OCPs
цена: 13000 руб.
Для юридических лиц: 13000 руб.

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

Oracle Database 11g: New Features for 9i OCPs

Код: 1Z0-055
Язык обучения: English
Тестовая система: Pearson VUE
Филиал: Москва


Exam Topics:

Installation and Upgrade Enhancements

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

Storage Enhancements

  • Create and maintain bigfile tablespaces
  • Rename tablespaces
  • Create a default permanent tablespace
  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Execute SQL commands with ASM file names
  • Use ASMCMD Command-Line Interface
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • Setup ASM fast mirror resynch
  • Understand scalability and performance enhancements

SQL Performance Analyzer

  • Using SQL Performance Analyzer

SQL Plan Management

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

Database Replay

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

Miscellaneous New Features

  • Describe and use the enhanced online table redefinition
  • Use fine-grained auditing for DML statements
  • Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
  • Use Query Result Cache and PL/SQL Result Cache
  • Create temporary tablespace groups
  • Assign temporary tablespace groups to users
  • Temporary Tablespace Enhancements

Oracle SecureFiles

  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication,


  • Use SQL and PL/SQL APIs to access Secure File LOBS

SQL Tuning

  • Use the SQL Tuning Advisor
  • SQL Access Advisor Overview
  • Create SQL Access Advisor analysis session using PL/SQL
  • Setup and modify Automatic SQL Tuning
  • Interpret reports generated by Automatic SQL Tuning
  • Use SQL Repair Advisor

Intelligent Infrastructure Enhancements

  • Monitor and maintain the AWR
  • Creating and using AWR baselines
  • Control Automated Maintenance Tasks
  • Using Database Resource Manager New Features
  • Simplify management tasks by using the Scheduler
  • Create a job, program, schedule and window
  • View information about job executions and job instances
  • Monitor and manage server-generated alerts

Performance Enhancements

  • Use Automatic Database Diagnostic Monitor (ADDM)
  • ADDM Enhancments in 11g
  • Use Automatic Shared Memory Management
  • Setup Automatic Memory Management
  • Enhancements in statistics collection

Space Management and Partitioning

  • Reduce space related error conditions through proactively managing tablespace usage
  • Reclaim wasted space from tables and indexes using the segment shrink functionality
  • Use the Segment Advisor
  • Use the Undo Advisor
  • Use Automatic Undo Retention Tuning
  • Implement the new partitioning methods
  • Employ Data Compression

Load and Unload Data

  • Transport tablespaces across different platforms
  • Explain Data Pump architecture
  • Monitor a Data Pump job
  • Use Data Pump export and import
  • Create external tables for data population

Backup and Recovery Enhancements

  • Simplify file management for all recovery-related file
  • Reduce restore time by applying incremental backups to data file image copies
  • Simplify recovery after opening the database with the RESETLOGS option
  • Speed backup times by creating faster incremental backups
  • Minimize load requirements by specifying limits in backup time windows
  • Save storage space through writing compressed backup sets
  • Managing Archive logs

Using Flashback and Logminer

  • Configure and use Flashback Database
  • Recover dropped tables with the Flashback Drop feature
  • Retrieve row history information with the Flashback Versions Query feature
  • Audit or recover FROM transactions with the Flashback Transaction Query feature
  • Recover tables to a point in time with the Flashback Table feature
  • Back-out transactions using Flashback Transaction

Diagnosability Enhancements

  • Setup Automatic Diagnostic Repository
  • Use Support Workbench
  • Run health checks

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

По вашему запросу ничего не найдено. Попробуйте изменить условия поиска.

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