1Z0-053 Oracle Database 11g: Administration II

 1Z0-053 Oracle Database 11g: Administration II  


Oracle OCP Exam Number: 1Z0-053

Associated Certifications: Oracle Database 11g Administrator Certified Professional

Exam Product Version: Oracle Database 11g

Exam Price: EGP 1126

Duration: 105 minutes

Number of Questions: 78

Passing Score: 66%

Validated Against:   The exam has been validated against Oracle® Database 11g Release 2 version

format:     Multiple Choice

Recommended Training: Oracle Database 11g: Administration Workshop II DBA Release 2

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



All Rights Reseved © Computekeg.com