1Z0-053: Oracle Database 11g - Administration II


Exam Number: 1Z0-053

Exam Title: Oracle Database 11g - Administration II


Associated Certification Paths



Oracle 1Z0-053 Certification Details:


Exam Name Oracle Database 11g - Administration II
Exam Code 1Z0-053
Exam Product Version Oracle Database 11g
Exam Price USD $245
Duration 120 minutes
Number of Questions 78
Passing Score 66%
Validated Against The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0.
Format Multiple Choice
Recommended Practice 1Z0-053 Online Practice Exam
Recommended Training Oracle Database 11g: Administration Workshop II DBA Release 2

Oracle 1Z0-053 Certification 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

Oracle 1Z0-053 - Oracle Database 11g - Administration II Exam Preparation: