Oracle 1Z0-034 Exam Preparation

Exam Name: Upgrade Oracle9i/10g OCA to Oracle Database OCP

148 Total Questions
Jun 6, 2019 updated
  • Exam Code: 1Z0-034
  • Certification Provider: Oracle

Purchase Individually

Practice Test
148 Total Question Jun 6, 2019 Updated
Questions & Answers (PDF)
148 Total Question Jun 6, 2019 Updated
Oracle Upgrade Oracle9i/10g OCA to Oracle Database OCP Exam Details
Technology Backup Administration, Recovery Concepts, System administrator
Audience Application Backup Manager, Recovery System Specialist
Related Certification(s) Oracle Database Application Development Certification


Free 3 month
Product Updates

100% Money Back

100% Real


Oracle 1Z0-034 Exam Major Topics

  • Backup and Recovery Concepts/ Describe ways to tune instance recovery/ Configure ARCHIVELOG mode
  • Identify the importance of checkpoints, redo log files, and archived log files
  • Identify the types of failure that can occur in an Oracle database/ Perform backup and recovery in NOARCHIVELOG mode
  • Using the RMAN Recovery Catalog/ Identify situations that require RMAN recovery catalog/ Back up the recovery catalog
  • Create and configure a recovery catalog/ Synchronize the recovery catalog/ Create and use a virtual private catalog
  • Using RMAN to Create Backups/ Create an archival backup for long-term retention/ Report on and maintain backups
  • Create duplex backup and back up backup sets/ Enable fast incremental backup/ Create a whole database backup and image file backups
  • Using RMAN to Perform Recovery/ Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform incomplete recovery using RMAN/ Perform Disaster recovery/ Recover using incrementally updated backups/ Restore a database onto a new host
  • Switch to image copies for fast recovery/ Recover using a backup control file
  • Using Flashback Technology/ Restore dropped tables from the recycle bin/ Describe the concepts of transportable tablespaces and databases
  • Perform Flashback Query/ Transport tablespaces across different platforms/ Transport Data and Tablespaces/ Use Flashback Transaction
  • Monitoring and Tuning RMAN/ Monitoring RMAN sessions and jobs/ Performing User-Managed Backup and Recovery/ Configure RMAN for Asynchronous I/O
  • Recover from a lost TEMP file, redo log group, password file/ Perform user-managed complete, incomplete database recovery/ Back up and recover a control file Perform user-managed database recovery/ Perform user-managed and server managed backups/ Identify the need of backup mode
  • Implement Automatic Memory Management/ Manually configure SGA parameters/ Configure automatic PGA memory management
  • Manage resumable space allocation/ Reclaim wasted space from tables and indexes by using the segment shrink functionality/ Implement partitioning methods
  • Reduce space related error conditions through proactively managing tablespace usage/ Use different storage options to improve the performance of queries
  • Customize language-dependent behavior for the database and individual sessions/ Query data using non-case-sensitive and accent-insensitive searches
  • Obtain globalization support configuration information/ Use automatic undo retention tuning and temporary undo/ Using Globalization Support
  • Specify different linguistic sorts for queries/ Use datetime datatypes/ Loading and Unloading Data/ Explain Data Pump architecture

Latest Preparation Material by ExamsTrainer

Corporate / Trainer License Program