1Z0-034: Upgrade Oracle9i/10g to Oracle Database 11g OCP


Exam Number: 1Z0-034

Exam Title: Upgrade Oracle9i/10g to Oracle Database 11g OCP


Associated Certification Paths



Oracle 1Z0-034 Certification Details:


Exam Name Upgrade Oracle9i/10g to Oracle Database 11g OCP
Exam Code 1Z0-034
Exam Product Version Oracle Database 11g
Exam Price USD $245
Duration 120 minutes
Number of Questions 98
Passing Score 61%
Validated Against This exam has been validated against Oracle Database 11g.
Format Multiple Choice
Recommended Practice 1Z0-034 Online Practice Exam
Recommended Training Oracle Database 11g: Administration Workshop II
Oracle Database 11g: New Features for Administrators DBA

Oracle 1Z0-034 Certification Topics:


1. Backup and Recovery

Backup and Recovery Concepts
  • Identify the types of failure that can occur in an Oracle database 
  • Describe ways to tune instance recovery 
  • Identify the importance of checkpoints, redo log files, and archived log files 
  • Configure ARCHIVELOG mode 
  • Perform backup and recovery in NOARCHIVELOG mode 
Configuring for Recoverability
  • Configure multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy
  • Configure Fast Recovery Area
  • Use the Fast 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
Diagnosing the Database
  • Set up Automatic Diagnostic Repository
  • Detect database corruptions using ANALYZE and DBVERIFY
  • Detect database corruptions using the dbms_repair package
  • Implement the DB_BLOCK_CHECKING parameter to detect corruptions
  • Repair corruptions using RMAN
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
Performing Tablespace Point-in-Time Recovery
  • Identify the situations that require TSPITR
  • Perform automated TSPITR
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
Transport Data and Tablespaces
  • Describe the concepts of transportable tablespaces and databases
  • Transport tablespaces across different platforms
Using RMAN to Duplicate a Database
  • Creating a duplicate database
  • Using a duplicate database
Monitoring and Tuning RMAN
  • Monitoring RMAN sessions and jobs
  • Tuning RMAN 
  • Configure RMAN for Asynchronous I/O
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
  • Setup ASM fast mirror resync
  • Use the md_backup, md_restore, and repair ASMCMD extensions
Performing User-Managed Backup and Recovery
  • Performing User-Managed Backup and Recovery
2. Database Administration

Installing and Upgrading
  • Install Oracle Database 11g
  • Upgrade your database to Oracle Database 11g
  • Oracle Direct NFS
  • Use online patching
Memory Management
  • Implement Automatic Memory Management
  • Manually configure SGA parameters
  • Configure automatic PGA memory management
Storage Management
  • Create and maintain bigfile tablespaces
  • Rename tablespaces
  • Create a default permanent tablespace
Space Management
  • Manage resumable space allocation
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Rebuild indexes online
  • Reduce space related error conditions through proactively managing tablespace usage
  • Use different storage options to improve the performance of queries 
  • Use automatic undo retention tuning and temporary undo
  • Implement  partitioning methods
Security
  • Configure the password file to use case sensitive passwords
  • Encrypt a tablespace
  • Configure fined grained access to network services
  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
Using Globalization Support
  • Customize language-dependent behavior for the database and individual sessions  
  • Specify different linguistic sorts for queries 
  • Use datetime datatypes 
  • Query data using non-case-sensitive and accent-insensitive searches
  • Obtain globalization support configuration information
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
  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs
Loading and Unloading Data
  • Explain Data Pump architecture
  • Monitor a Data Pump job
  • Use Data Pump export and import
  • Create external tables for data population
Managing Resources
  • Configure the Resource Manager
  • Assign users to Resource Manager groups
  • Create resource plans within groups
  • Specify directives for allocating resources to consumer groups
Managing Database Performance
  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload
  • Use Database Replay
  • Gather and use optimizer statistics
  • Use Adaptive Cursor Sharing
  • Diagnose performance issues using ASH

Oracle 1Z0-034 - Upgrade Oracle9i/10g to Oracle Database 11g OCP Exam Preparation: