Certification exams change, and study material has to keep up. The 1z0-074 (Oracle Upgrade Oracle DBA 11g or 12c to 12c R2) question bank at Actual4Exams is reviewed continuously and comes with 365 days of free updates, so your 2026 preparation always reflects the current exam.
Oracle 1z0-074 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Upgrade Oracle DBA 11g or 12c to 12c R2 |
| Exam Number: | 1Z0-074 |
| Real Exam Qty: | 75 |
| Exam Price: | $245 USD |
| Certificate Validity Period: | 18 months from certification date |
| Exam Format: | Multiple Response, Multiple Choice |
| Exam Duration: | 120 minutes |
| Available Languages: | Japanese, English, Simplified Chinese |
| Related Certifications: | Oracle Database 11g Administrator Certified Professional Oracle Database 12c Administrator Certified Professional |
| Passing Score: | 63% |
| Recommended Training: | Oracle Learning Subscription Oracle Database 12c R2: New Features for Administrators |
| Exam Registration: | Oracle Certification Portal Pearson VUE Registration |
| Sample Questions: |  |
| Exam Way: | Online proctored or onsite at Pearson VUE test centers |
| Pre Condition: | Recommended: Hold Oracle Database 11g or 12c Administrator certification; no mandatory exam prerequisites |
| Official Syllabus URL: | https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-074 |
Oracle 1z0-074 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Tools & New Features | 15% | - Describe SQL and PL/SQL improvements - Use Oracle Data Pump enhancements - Use online table and partition move - Leverage ADR and diagnostic enhancements |
| Topic 2: Performance & Storage | 20% | - Use In-Memory Column Store - Optimize performance across CDB and PDBs - Implement partitioning enhancements - Manage optimizer statistics and advisors - Manage ASM instances, disk groups and storage |
| Topic 3: Database Upgrade & Migration | 15% | - Use transportable tablespaces and cross-platform backups - Upgrade database from 11g or 12c R1 to 12c R2 - Migrate on-premises database to Oracle Cloud |
| Topic 4: Backup & Recovery | 15% | - Restore from encrypted PDB backups - Recover and flashback CDBs and PDBs - Manage RMAN backups and recovery catalogs |
| Topic 5: Security & Auditing | 15% | - Manage common and local users, roles and privileges - Use data redaction and column encryption - Implement unified auditing and TSDP policies |
| Topic 6: Multitenant Architecture | 20% | - Relocate and unplug/plug PDBs - Create and manage CDBs and PDBs - Manage application containers, roots and seeds - Configure proxy PDBs and cross-CDB queries |
Common Questions About the Oracle 1z0-074 Exam
The 1z0-074 exam, officially known as Oracle Upgrade Oracle DBA 11g or 12c to 12c R2, is the Oracle test that leads to the Oracle Database 12c R2 Administrator Certified Professional 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 Oracle Database 11g Administrator Certified Professional, Oracle Database 12c Administrator Certified Professional.
The 1z0-074 exam contains 75 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 1z0-074 exam is 63%, and the official registration fee is $245 USD. 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.
Recommended: Hold Oracle Database 11g or 12c Administrator certification; no mandatory exam prerequisites
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-074.
You can book the 1z0-074 exam through the official registration channels below:
Exam delivery: Online proctored or onsite at Pearson VUE 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 Oracle DBA 11g or 12c to 12c R2 candidates:
Pair any course with the 75 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 Oracle DBA 11g or 12c to 12c R2 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 1z0-074 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 Oracle DBA 11g or 12c to 12c R2 outline is organized into 6 domains. The first three are:
- Database Upgrade & Migration — 15% of the exam
- Tools & New Features — 15% of the exam
- Security & Auditing — 15% of the exam
See the complete exam topics section above for the full outline and the weighting of every domain.
Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 Sample Questions:
In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?
- A. nobody
- B. opc
- C. oracle
- D. oinstall
- E. grid
Correct Answer: B 🗳️
The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2.
USER1 is a local user in PDB1 and has the SYSBACKUP privilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora.
Examine these commands executed by USER1 when all PDBs are open:
What is the outcome and why?
- A. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL"<command>".
- B. An error is returned because the user is not SYS.
- C. An error is returned because the user is connected to a pluggable database.
- D. The current date is displayed.
- E. An error is returned because the user is not a common user.
Correct Answer: D 🗳️
USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?
- A. Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.
- B. Grant SYSRAC to ops$user1.
- C. Grant SYSRAC to user1.
- D. Grant SYSDBA to ops$user1
- E. Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.
Correct Answer: B 🗳️
The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable databases (PDBs) PDB1 and PDB2.
A connect descriptor for TESTDB is mapped to the TNS alias testdb in tnsnames.ora.
The default RMAN configuration is used.
Examine these commands:
Which files are backed up?
- A. all root and PDB1 data files, and the CONTROLFILE and SPFILE
- B. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and FLASHBACKLOGS
- C. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and ARCHIVELOGS
- D. all root and PDB1 data files
- E. all root and PDB1 data files, and the CONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS
Correct Answer: D 🗳️
Identify a situation where performance profiles can be used for application containers.
- A. to enforce a limit on I/O throughput per second
- B. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out
- C. to enforce a limit on the number of I/OS issued per second
- D. to specify the total number of parallel execution servers available
- E. to specify the maximum percentage of the parallel execution server pool that a particular application container can use
Correct Answer: D 🗳️
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 1z0-074 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 1z0-074 exam.
We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the Oracle 1z0-074 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 1z0-074 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.
