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 | |