
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 NowNext up:
- Microsoft and Cisco team-up to fix Azure ExpressRoute Network Issues
- Do you really want to take innovation seriously in 2018?
- How to deal with Big Data
- How to leverage on data-driven marketing strategies
- Impress your boss with your data-driven Microsoft skills
- Comptia Certifications: Why you should get CompTIA certified
- Microsoft Certifications: the why and the how
- Oracle Certifications: A visible way to demonstrate your knowledge
- VMware Certifications: Climbing the VMware certification ladder
- Cisco releases Annual Cybersecurity Report
Previously
- The Skills Required for Tomorrow's Technology Practitioners
- Amazing Cities and Sites in Australia
- Project Management Careers in Australia
- From Bulgaria to Australia
- Customer Service 101's really can make a difference
- Smarter Selling is the Future of Selling
- The I in Problem Solving
- The Most Amazing Trip In My Life!
- Disrupted Student Support
- Dynamics 365 - Why every business should make the jump.