Oracle 1Z0-034 Certification Exam Syllabus

1Z0-034 Syllabus, 1Z0-034 Dumps PDF, Oracle OCP Dumps, 1Z0-034 Dumps Free Download PDF, Oracle Database OCP Dumps, 1Z0-034 Latest Dumps Free DownloadYou can use this exam guide to collect all the information about Upgrade Oracle9i/10g to Oracle Database 11g OCP (1Z0-034) certification. The Oracle 1Z0-034 certification is mainly targeted to those candidates who has some experience or exposure of Oracle Database and want to flourish their career with Oracle Database 11g Administrator Certified Professional (upgrade) (OCP) credential. The Upgrade Oracle9i/10g to Oracle Database 11g OCP certification exam validates your understanding of the Oracle Database technology and sets the stage for your future progression. Your preparation plan for Oracle 1Z0-034 Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following Certification Exam Topics table.

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 (Pricing may vary by country or by localized currency)
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 Training
Schedule Exam Pearson VUE - Oracle
Recommended Practice 1Z0-034 Online Practice Exam

Oracle 1Z0-034 Certification Topics:

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
- 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
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

The Oracle 1Z0-034 Certification Program certifies candidates on skills and knowledge related to Oracle Database products and technologies. The Oracle Database 11g Administrator Certified Professional (upgrade) is granted based on a combination of passing exams, training and performance-based assignments, depending on the level of certification. Oracle 1Z0-034 certification is tangible benchmark of experience and expertise that help you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exam and hands-on experience to prepare for your Upgrade Oracle9i/10g to Oracle Database 11g OCP certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.

Rating: 5 / 5 (34 votes)