Oracle Database 11g: Administration II


Duration: 120 minutes
 Number of Questions: 78
Passing Score: 66% (Passing score subject to change)

Exam Topics:

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

No comments:

Post a Comment