Oracle 1z0-074 Exam Details & Actual Exam Questions
- Exam Code/Number: 1z0-074
- Exam Name/Title: Upgrade Oracle DBA 11g or 12c to 12c R2
- Certification Provider: Oracle
- Corresponding Certification: Oracle Database 12c R2
- Exam Questions: 75
- Updated On: Sep,20 2026
- Certification Level: Professional
Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 Exam Questions
View 1z0-074 actual exam questions, answers and explanations for free.
93% student found the test questions almost same
All the information you need to pass Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 1z0-074 exam and free practice exam verified by EduDump exam experts.
Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
This exam has been stopped to register, new exam code replace: 1z0-083
Oracle 1z0-074 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Upgrade Oracle DBA 11g or 12c to 12c R2 |
| Exam Number: | 1Z0-074 |
| Passing Score: | 63% |
| Real Exam Qty: | 75 |
| Certificate Validity Period: | 18 months from certification date |
| Exam Duration: | 120 minutes |
| Available Languages: | Japanese, English, Simplified Chinese |
| Exam Price: | $245 USD |
| Related Certifications: | Oracle Database 11g Administrator Certified Professional Oracle Database 12c Administrator Certified Professional |
| Exam Format: | Multiple Choice, Multiple Response |
| Recommended Training: | Oracle Learning Subscription Oracle Database 12c R2: New Features for Administrators |
| Exam Registration: | Pearson VUE Registration Oracle Certification Portal |
| Sample Questions: | Oracle 1z0-074 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: Multitenant Architecture | 20% | - Create and manage CDBs and PDBs - Manage application containers, roots and seeds - Relocate and unplug/plug PDBs - Configure proxy PDBs and cross-CDB queries |
| Topic 2: Tools & New Features | 15% | - Leverage ADR and diagnostic enhancements - Describe SQL and PL/SQL improvements - Use online table and partition move - Use Oracle Data Pump enhancements |
| Topic 3: Performance & Storage | 20% | - Use In-Memory Column Store - Optimize performance across CDB and PDBs - Manage optimizer statistics and advisors - Implement partitioning enhancements - Manage ASM instances, disk groups and storage |
| Topic 4: Security & Auditing | 15% | - Manage common and local users, roles and privileges - Implement unified auditing and TSDP policies - Use data redaction and column encryption |
| Topic 5: Database Upgrade & Migration | 15% | - Use transportable tablespaces and cross-platform backups - Migrate on-premises database to Oracle Cloud - Upgrade database from 11g or 12c R1 to 12c R2 |
| Topic 6: Backup & Recovery | 15% | - Restore from encrypted PDB backups - Recover and flashback CDBs and PDBs - Manage RMAN backups and recovery catalogs |
0
0
0
10