1Z0-074

Upgrade Oracle DBA 11g or 12c to 12c R2 (OCP)

Candidates for the Upgrade Oracle DBA 11g or 12c to 12c R2 (OCP) certification exam are database administrators, system administrators, support engineers, and technical consultants. This certification is a prerequisite to the Upgrade to Oracle Database 12c R2 Administration Certified Professional certification.

This exam measures the following skills*:

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

For more information about the 1Z0-074 exam, visit the Oracle site.

*These exam objectives can change at any time.

1Z0-074 Upgrade Oracle DBA 11g or 12c to 12c R2 (OCP) Certification Study Package

Kaplan IT Training Certification Packages are based on Kaplan's proven learning strategy of Prepare, Practice, Perform® and are customizable to fit your preferred study method. Study at your own pace, whenever you want, and wherever you are most comfortable. Choose between our 30-Day Assessment and 180-Day Exam Preparation. Practice with exam-like questions. 

30-Day Assessment (Online only)

  • A single set of focused exam-like questions
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Online access only
  • Upgrade to the 180-Day Exam Preparation for only $40

180-Day Exam Preparation (Online + Download)

  • Multiple unique sets of exam-like questions for additional exam experiences
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Performance Tracker to see how your performance stacks up to others
  • Full set of key concepts flashcards to memorize critical information
  • Online access and downloadable and printable quizzes for offline study
  • Study Calendar to optimize your exam study time
  • Student Discussion Board to share study tips
  • InstructorLink™ to contact our IT experts
  • Pass Guarantee to ensure your success

Build Your Package:

Kaplan IT Training Certification Package Grid Image