Certification News from Oracle

 Jan 23, 2018

Upgrading to Oracle Database 12c R2 Administration Certified Professional with One Exam 

Customers who are currently an Oracle Database 11g or 12c Administrator Certified Professional can upgrade their certification to Oracle Database 12c R2 Administration Certified Professional by passing one exam: Upgrade Oracle DBA 11g or 12c to 12c R2 (code 1Z0-074).

Passing this exam proves customers have the advanced knowledge and skills required of top-performing database administrators, including development and deployment of backup, recovery and Cloud computing strategies. 

We recommended the following training courses

  • Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 and
  • Oracle Database 12c R1: New Features for Administrators Ed 2

The Exam duration is 120 minutes, with a total of 75 questions. To pass you must achieve a 63% pass rate.

Exam Topics Cover:


Using CDBs and Application Containers

Describe the application root and application seed

Create an application container

Explain application install and upgrade


Managing Users and Users Access to Data in a Multitenant Environment

Manage common and local users, privileges, roles and objects in application containers

Manage PDB Lockdown profile


Creating Different Types of PDBs

Unplug and plug an encrypted PDB in one-step operation

Describe near-zero downtime PDB relocation with local UNDO tablespaces

Configure a proxy PDB and query data across CDBs


Recovering and Flashing back CDBs and PDBs

Use PDB close abort to recover a PDB from SYSTEM tablespace damage

Perform flashback PDBs


Managing Performance in PDBs and CDBs

Manage memory allocation between PDBs 

Manage resources allocation between PDBs with Resource Manager Performance Profile


Upgrading Database from 11g or 12.1 to 12.2

Upgrade CDBs to 12.2

Use cross-platform PDB backupsets to import into a CDB


Creating and Managing Profiles and Privileges

Enhance the security of administrative users 


Performing Unified Auditing

Audit all users to whom roles are granted directly


Using Data Redaction

Create and reuse redaction formats from library


Using Data Encryption

Encrypt / decrypt / re-key all tablespaces online


Using TSPD policies with Auditing and Column Encryption

Use TSDP policies with other Oracle features like auditing and column encryption


Creating and Managing backup and recovery catalog

Upgrade and drop the catalog in one command

Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE

Describe REPAIR FAILURE enhanced command

Describe the filtered partition maintenance operations


Recovering a database

Perform incomplete recover

Restore and recover database

Recover table 


Transporting a tablespace

Transport encrypted tablespace

Describe the online table and partition move features

Use upfront check on available disk space and REMAP TABLE to complete a table recovery across schemas

Describe some more non-blocking DDLs 


Using Oracle Data Pump, SQL*Loader and External Tables

Explain Oracle Data Pump enhancements


Performing In Memory Column Store

Explain how to deploy the in-memory column store in a database (static and dynamic)


Tuning SQL Statements

Describe the Optimizer Statistics Advisor

Use SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence

* Triggers with DMLs

* Usage of SYSDATE

* Rows to fetch

New SQL JOIN processing

Continuous Adaptive Query Plans

Use Adaptive Execution Plans

Use enhanced features of statistics gathering


Memory and Other Performance Enhancements

Manage session PGA limit

Reduce cursor invalidations for DDLs

Describe the Advanced Index Compression ( HIGH )

Manage real-time materialized views with on query computation


Applying Different Types of Partitioning

Explain Interval Subpartitioning

Explain Auto-List Partitioning and Subpartitioning

Describe composite partitioning

Describe read-only partition



Describe DB Operation enhancements (some enhancements deferred out of


Using Diagnostic Enhancements

Describe ADR file automatic space management

Collect diagnostic information by using TFA 

Trace data pump operations while job is running

Diagnose refresh performance issues related to MV refreshed statistics 


Managing Oracle Database Cloud Services

Describe the Oracle Public Cloud Services

Describe the Oracle Database Cloud Services console

Create a database deployment

Explain database deployment backup and recovery automatic procedures

Monitor database deployment using DBaaS Monitor console

Describe the differences between database deployments and on-premises databases

Migrate on-premises database to Oracle Database Public Cloud Services


Using SQL Enhancements

Describe the new SQLcl utility

Describe the SQL identifiers new lengths

Describe the new VALIDATE_CONVERSION function


Using Information Lifecycle Management and Storage Enhancements)

Use ILM features


Administrating Storage

Administer ASM Instances, ASM Diskgroups and ASM disk


Within 30 minutes of completing your Oracle Certification exam, you will receive an email from Oracle notifying you that your exam results are available. 


We wish you well! Talk to us if you're interested in further developing your Oracle skills.


How do your Excel skills stack up?   

Test Now  

About the Author:

New Horizons  

New Horizons is Australia's leading corporate training provider, and has been educating business professionals for over 15 years in the areas of Professional Development, Microsoft Office & Adobe Applications, and IT Technical. Our aim through this blog is to bring you relevant stories, articles, and tips & tricks that can help you to improve your skills and productivity in the workplace. Our expert trainers will also be posting their own articles from time to time, so be sure to keep an eye out.

Read full bio
Back to top