Oracle 1Z0-053

Free Questions in OTE format

About Oracle 1Z0-053 dump

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