Hi Readers

Finally, I’ve successfully passed 1Z0-074, Upgrade Oracle DBA 11g or 12c to 12c R2. It was almost more than 3 months that I’ve been preparing for this.

The Exam contains 75 questions related to Oracle Database 12cR2 New Features. To earn this certification you need to get 63% marks.

This was the result of the journey: Oracle Certified Professional, Database 12cR2 Administration.

In this post you will find:

  • A path to achieve it
  • Study Materials
  • Exam Detail & Score

How to Achieve this Certification?

Before appearing to this exam you must have the vast knowledge of Oracle Database 12cR2 and Oracle Database Cloud.

List of exam topics

  • Using CDBs and Application Containers
  • Creating Different Types of PDBs
  • Managing Performance in PDBs and CDBs
  • Creating and Managing Profiles and Privileges
  • Using Data Redaction
  • Using TSPD policies with Auditing and Column Encryption
  • Recovering a database
  • Using Oracle Data Pump, SQL*Loader and External Tables
  • Tuning SQL Statements
  • Applying Different Types of Partitioning
  • Using Diagnostic Enhancements
  • Using SQL Enhancements
  • Administrating Storage
  • Managing Users and Users Access to Data in a Multitenant Environment
  • Recovering and Flashing back CDBs and PDBs
  • Upgrading Database from 11g or 12.1 to 12.2
  • Performing Unified Auditing
  • Using Data Encryption
  • Creating and Managing backup and recovery catalog
  • Transporting a tablespace
  • Performing In-Memory Column Store
  • Memory and Other Performance Enhancements
  • Manageability
  • Managing Oracle Database Cloud Services
  • Using Information Lifecycle Management and Storage Enhancements)

For more detail, you can follow the below link.


How to prepare for the exam?

There is only one way to study for this exam

  1. Oracle Database 12c R2: New Features for 12c R1 Administrators

How to register for the exam?

If you want to enroll exam, please click on below link.

Exam Number: 1Z0-074

Exam Title: Upgrade Oracle DBA 11g or 12c to 12c R2


Below are the Exam Details related to scoring.

There is a nice post from my fellow DBA – Alex Zaballa

You Should Avoid Brain Dumps When Preparing for Certifications

Special Thanks

Joel Perez is an Oracle OCM and ACED who gave an opportunity to write him and motivating me to learn new things.  I’m very thankful to him as this was the kick off for my studies.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.