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 12.1.0.1 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

 

Manageability

Describe DB Operation enhancements (some enhancements deferred out of 12.2.0.1)

 

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
top
Back to top