Earning the Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP credential tells employers you can work with Oracle technologies at a professional level. Prepare for the 1z1-034 exam in 2026 with the 148 expert-prepared practice questions from Actual4Exams.
Oracle 1z1-034 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP |
| Exam Number: | 1Z0-034 |
| Real Exam Qty: | 98 |
| Exam Price: | USD 245 |
| Related Certifications: | Oracle Database 10g Administrator Certified Associate Oracle9i Database Administrator Certified Associate |
| Passing Score: | 61% |
| Available Languages: | Japanese, English |
| Exam Format: | Single-choice multiple choice, Multiple-choice multiple choice |
| Certificate Validity Period: | Does not expire (valid for version 11g) |
| Exam Duration: | 120 minutes |
| Recommended Training: | Oracle Database 11g: New Features for Administrators |
| Exam Registration: | Pearson VUE Oracle Education |
| Sample Questions: |  |
| Exam Way: | Online proctored or onsite at Pearson VUE authorized test centers |
| Pre Condition: | Must hold valid Oracle9i OCA or Oracle Database 10g OCP credential; may also require completing Oracle University training to obtain full OCP |
| Official Syllabus URL: | https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-034 |
Oracle 1z1-034 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Performance & Diagnostics | 8% | - SQL Tuning Advisor - Adaptive Cursor Sharing - AWR, ADDM and ASH |
| Topic 2: Data Movement & Loading | 6% | - Transportable tablespaces/databases - Data Pump export/import - External tables |
| Topic 3: Flashback Technology | 7% | - Flashback Database - Flashback Query, Table and Drop |
| Topic 4: Installation & Upgrade | 4% | - Post-upgrade tasks - Upgrade methods and DBUA |
| Topic 5: Backup & Recovery Concepts | 10% | - Failure types and recovery options - ARCHIVELOG and NOARCHIVELOG mode - Fast Recovery Area configuration |
| Topic 6: RMAN Configuration & Catalog | 10% | - Configure RMAN environment - Use and maintain recovery catalog |
| Topic 7: Memory Management | 8% | - Automatic Memory Management - SGA and PGA configuration |
| Topic 8: Storage & Space Management | 12% | - Segment shrink and resumable allocation - Tablespaces, segments and extents - Partitioning |
| Topic 9: RMAN Backup & Recovery | 12% | - Duplicate a database - Create and manage backups - Perform complete and incomplete recovery |
| Topic 10: Database Architecture & ASM | 10% | - Instance and database structure - Automatic Storage Management |
| Topic 11: Globalization Support | 5% | - Linguistic sorts and datetime formats - Case-insensitive queries |
| Topic 12: User-Managed Backup & Recovery | 8% | - Complete and incomplete recovery - Recover lost files and control files |
Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP (1z1-034) — Questions Candidates Actually Ask
The 1z1-034 exam, officially known as Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP, is the Oracle test that leads to the Oracle Database 11g Administrator Certified Professional (OCP) certification at the Professional level. Passing it validates the skills employers expect from a certified professional. It is also associated with related credentials such as Oracle9i Database Administrator Certified Associate, Oracle Database 10g Administrator Certified Associate.
The 1z1-034 exam contains 98 questions, and you have 120 minutes to complete them. Work out your per-question pace before test day, and flag slow items instead of stalling on them — time pressure, not knowledge, sinks many first attempts. Timed mock exams in the Actual4Exams test engines are the most reliable way to build that rhythm.
The passing score for the 1z1-034 exam is 61%, and the official registration fee is USD 245. If you miss the mark, a retake means paying the full fee again, so book your seat only when you are ready. A practical benchmark: score consistently above the passing line on timed practice tests before scheduling the real exam.
Must hold valid Oracle9i OCA or Oracle Database 10g OCP credential; may also require completing Oracle University training to obtain full OCP
Entry requirements can change, so confirm the latest conditions on the official exam page: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-034.
You can book the 1z1-034 exam through the official registration channels below:
Exam delivery: Online proctored or onsite at Pearson VUE authorized test centers. Seats at popular test centers fill quickly, so schedule early once your preparation is on track.
Oracle recommends the following training options for Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP candidates:
Pair any course with the 148 practice questions from Actual4Exams to measure how ready you really are before paying the exam fee.
Yes. A free PDF demo of the Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP questions is available, so you can check the question style and answer quality before you pay. Every purchase also includes 365 days of free updates, and if the product expires you can renew the update service at a 50% discount from your member zone.
If you take the corresponding 1z1-034 exam within 60 days of purchase and do not pass, you can apply for a full refund under the 100% Money Back Guarantee: submit a scan of your enrollment slip and your official Score Report (PDF) within 2 days of the exam date, and the claim is processed within 7 days. Attempts made within 3 days of purchase, downloads without an actual exam attempt, free materials, and expired orders are not eligible, and the candidate name must match the payer name. Prefer new material instead of a refund? You can exchange your purchase for two free products of equal value and keep the update service on your original product. As for delivery, the files are available for instant download and are also emailed to you within one minute of payment — if nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you can install the product on.
The official Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP outline is organized into 12 domains. The first three are:
- Performance & Diagnostics — 8% of the exam
- Backup & Recovery Concepts — 10% of the exam
- Installation & Upgrade — 4% of the exam
See the complete exam topics section above for the full outline and the weighting of every domain.
Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP Sample Questions:
Question 1
Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?
A. Nested plans only control resources used by recursive SQL
B. Nested plans control only the degree of parallelism and I/O requests
C. Each nested plan gets a proportion of the CPU resources assigned to its parent group.
D. The plans can be nested up to four levels.
E. Only one nested subplan is allowed per parent plan
Question 2
View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.
Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?
ASM-disk-group-1 (exhibit):
ASM-disk-group-2 (exhibit):
A. Because the disk repair time attribute is set to a nonzero value
B. Because the other three disks have 60% free space, the disk rebalancing is delayed
C. Because the disk group is created with NORMAL redundancy
D. Because the mirrored extents cannot be rebalanced across the other three disks
Question 3
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
A. Only a single partitioning key column can be specified.
B. Traditional partition pruning and partitionwise joins are not supported on these tables.
C. All DML statements must use partition-extended syntax.
D. The same physical attributes must be specified for each partition.
E. Unique local indexes cannot be created on a system-partitioned table.
Question 4
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?
A. The recovery catalog is empty
B. A target database is registered in the recovery catalog
C. A base catalog exists
D. The base recovery catalog must be dropped
Question 5
Which two statements are true regarding hot patching? (Choose two.)
A. It is available for installing all patches on all platforms.
B. It requires relinking of the Oracle binary.
C. It can detect conflicts between two online patches.
D. It works only in a single database instance environment.
E. It does not require database instance shutdown.
Solutions:
| Question 1 Answer: C | Question 2 Answer: A | Question 3 Answer: B,E | Question 4 Answer: C | Question 5 Answer: C,E |
No help, Full refund!
Actual4Exams confidently stands behind all its offerings by giving Unconditional "No help, Full refund" Guarantee. Since the time our operations started we have never seen people report failure in the Oracle 1z1-034 exam after using our products. With this feedback we can assure you of the benefits that you will get from our products and the high probability of clearing the 1z1-034 exam.
We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the Oracle 1z1-034 exam really painful and disappointing. Although we cannot reduce your pain and disappointment but we can certainly share with you the financial loss.
This means that if due to any reason you are not able to pass the 1z1-034 actual exam even after using our product, we will reimburse the full amount you spent on our products. you just need to mail us your score report along with your account information to address listed below within 7 days after your unqualified certificate came out.
