1Z0-063 : Oracle Database 12c Administrator Certified Professional

Oracle Database 12c Administrator Certified Professional
ISBN : 978-1-61691-490-5
The Oracle Certified Professional credential shows that you have the skill and technical expertise to manage and implement enterprise databases. The OCP tier challenges you to demonstrate your continuing experience and knowledge of Oracle technologies. The OCP test will measure your knowledge in setting up and managing multitenant architecture databases and in backup and recovery.


uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keep the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keep learners engaged and make learning fun.

Here's What You Get

Exercises Flashcards Quizzes Glossary

Each lesson comes with Exercises, Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Exercises come with detailed remediation, which ensures that learners are confident on the topic before proceeding. Flashcards help master the key concepts. Glossary defines the key terms.

Exercise Questions
Glossary of terms

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
Full Length Tests
Post-Assessments Questions


Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Exam Information

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role.

The Oracle Database 12c Administrator Certified Professional certification requires you to have the OCA certification as well as to pass the 1Z0-063 exam.

Prepare for the following certification

Career Prospects
  • Server Administrator
  • SQL Developer
  • Database Administrator
  • Oracle Programmer
  • DBA
Exam FAQs
What is the exam registration fee?
USD 245

Pricing and taxes may vary from country to country. Click here for more information on exam pricing.

Where do I take the exam?
The 1Z0-063 exam is administered by Pearson VUE at the testing centers worldwide. Click here to find a testing center near you.
What is the format of the exam?
The exam consists scenario-based multiple choice questions.
What are the pre-requisites of the exam?

While there are no official prerequisites to take the Oracle Database 12c Administrator Certified Professional certification, both Oracle and uCertify strongly recommend that the candidates have a good understanding of the following:

  • Oracle Database 12c: Backup and Recovery Workshop
  • Oracle Database 12c: Managing Multitenant Architecture
How many questions are asked in the exam?
The exam contains 80 questions.
What is the duration of the exam?
120 minutes
What is the passing score?
What is the exam's retake policy?

Retake Policy for Oracle 1Z0-063 exam is:

  • Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)
  • Candidates may retake an online non-proctored exam at any time.
  • Candidates may not retake a passed exam at any time.
  • Candidates may not retake a beta exam at any time.
What is the validity of the certification?
Oracle certifications have no expiration. The certification holder is certified for life unless Oracle changes its policy. Click here for more information.
Where can I find more information about this exam?
To know more about the 1Z0-063, click here.

Table of Content

Here's What you will Learn

Lesson 1: Performing Oracle User-Managed Backups

  • Oracle Database Data Protection Options
  • Understanding the Oracle Database as It Relates to Backup and Recovery
  • Configuring the Database for Backup and Recovery
  • Performing Oracle Offline Backups
  • Performing Oracle Online Backups
  • Backing Up the Control File
  • Summary
  • Exam Essentials

Lesson 2: Performing Oracle User-Managed Database Recoveries

  • Performing a Recovery in NOARCHIVELOG Mode
  • Performing a Full Database Recovery in ARCHIVELOG Mode
  • Performing User-Based Incomplete Recoveries
  • Performing Other Types of Recoveries
  • Summary
  • Exam Essentials

Lesson 3: Configuring and Backing Up Oracle Databases Using RMAN

  • Why Use RMAN?
  • Exploring the RMAN Architecture
  • Getting Started with RMAN
  • Configuring RMAN
  • Backing Up Your Database with RMAN
  • Summary
  • Exam Essentials

Lesson 4: Using the RMAN Recovery Catalog

  • Introducing the Recovery Catalog
  • Creating the Recovery Catalog User and Schema Objects
  • Using a Recovery Catalog
  • Using Scripts in the RMAN Recovery Catalog
  • Maintaining the Recovery Catalog
  • Using the RMAN Virtual Private Catalog
  • Summary
  • Exam Essentials

Lesson 5: Recovering Databases with RMAN

  • RMAN Database-Recovery Basics
  • Recovering a Database in NOARCHIVELOG Mode
  • Recovering a Database in ARCHIVELOG Mode
  • Recovering a Database Using Incomplete Recovery
  • Using Image Copies to Recover Your Database
  • Other Basic Recovery Topics
  • Summary
  • Exam Essentials

Lesson 6: Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow

  • Overview of the RMAN Report and List Commands
  • Monitoring, Administering, and Tuning RMAN
  • The Oracle Database Fault Diagnostic Framework
  • Summary
  • Exam Essentials

Lesson 7: Performing Oracle Advanced Recovery

  • Switching between RMAN Incarnations
  • Overview of RMAN Database Duplication
  • Performing an RMAN Tablespace Point-in-Time Recovery
  • Restoring a Database to a New Host
  • Backup Best Practices for Data Warehouses
  • Performing Table and Partition Recovery from Backups
  • ASM-Related Backups
  • Configuring and Using Oracle Secure Backup
  • Oracle Database 12c Multitenant Architecture and RMAN
  • Summary
  • Exam Essentials

Lesson 8: Understanding Flashback Technology

  • Describe the Flashback Technologies
  • Managing Undo Automatically
  • Employing Flashback Technologies
  • Perform Flashback Database Operations
  • Summary
  • Exam Essentials

Lesson 9: Diagnosing the Database and Managing Performance

  • Diagnosing Failures
  • Managing Database Performance
  • Summary
  • Exam Essentials

Lesson 10: Managing Database Resources

  • Managing Storage
  • Managing Storage in a CDB and PDBs
  • Summary
  • Exam Essentials

Lesson 11: Creating Oracle Multitenant Databases

  • Multitenant Container and Pluggable Database Architecture
  • Creating Multitenant Container Databases and Pluggable Databases
  • Summary
  • Exam Essentials

Lesson 12: Managing Oracle Multitenant Databases

  • Establishing Connections to CDB/PDB
  • Start Up and Shut Down a CDB and Open and Close PDBs
  • Evaluate the Impact of Parameter Value Changes
  • Summary
  • Exam Essentials

Lesson 13: Oracle Utilities

  • Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
  • Summary
  • Exam Essentials

Lesson 14: Oracle Security in CDBs and PDBs

  • Managing Security in a CDB and PDBs
  • Summary
  • Exam Essentials

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved