Código: 1Z0-053

Prova Oracle Database 11g: Administration II
Preço R$ 326,00
Duração 120 minutos
Número de questões 78
Nota de aprovação 66%
Treinamento oficial recomendado Oracle Database 11g: Administration Workshop II DBA Release 2

Tópicos do exame

Database Architecture and ASM
Describe Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups
Configuring for Recoverability
Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area
Using the RMAN Recovery Catalog
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create and use a virtual private catalog
Configuring Backup Specifications
Configure backup settings
Allocate channels to use in backing up
Configure backup optimization
Using RMAN to Create Backups
Create image file backups
Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups
Performing User-Managed Backup and Recovery
Recover from a lost TEMP file
Recover from a lost redo log group
Recover from the loss of password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file
Using RMAN to Perform Recovery
Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery
Using RMAN to Duplicate a Database
Creating a duplicate database
Using a duplicate database
Performing Tablespace Point-in-Time Recovery
Identify the situations that require TSPITR
Perform automated TSPITR
Monitoring and Tuning RMAN
Monitoring RMAN sessions and jobs
Tuning RMAN
Configure RMAN for Asynchronous I/O
Using Flashback Technology
Restore dropped tables from the recycle bin
Perform Flashback Query
Use Flashback Transaction
Additional Flashback Operations
Perform Flashback Table operations
Configure, Monitor Flashback Database and Perform Flashback Database operations
Set up and use a Flashback Data Archive
Diagnosing the Database
Set up Automatic Diagnostic Repository
Using Support Workbench
Perform Block Media Recovery
Managing Memory
Implement Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management
Managing Database Performance
Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Understand Database Replay
Space Management
Manage resumable space allocation
Describe the concepts of transportable tablespaces and databases
Reclaim wasted space from tables and indexes by using the segment shrink functionality
Managing Resources
Understand the database resource manager
Create and use Database Resource Manager Components
Automating Tasks with the Scheduler
Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks
Administering the Scheduler
Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs