.png){kind=logo}
1Z0-063-2nd
Oracle DB 12c Administrator Certified Professional
- Practice in 36 Hands-On Labs — nothing to install
- 14 Interactive Lessons and 82 topics mapped to the official exam objectives
- 330 Practice Test Questions and 2 Full Length Tests
Expert Self-paced · 1 year access
36 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
14Interactive Lessons
82Topics
36LiveLab
330Practice Test Questions
107Flashcards
107Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
14 Interactive Lessons · 82 topics01 Performing Oracle User-Managed Backups 8 topics · 5 LiveLab +
- 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
5 LiveLab in this lesson — see the labs panel →
02 Performing Oracle User-Managed Database Recoveries 6 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
03 Configuring and Backing Up Oracle Databases Using RMAN 7 topics · 3 LiveLab +
- Why Use RMAN?
- Exploring the RMAN Architecture
- Getting Started with RMAN
- Configuring RMAN
- Backing Up Your Database with RMAN
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
04 Using the RMAN Recovery Catalog 8 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
05 Recovering Databases with RMAN 8 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
06 Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow 5 topics · 3 LiveLab +
- Overview of the RMAN Report and List Commands
- Monitoring, Administering, and Tuning RMAN
- The Oracle Database Fault Diagnostic Framework
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
07 Performing Oracle Advanced Recovery 11 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
08 Understanding Flashback Technology 6 topics · 3 LiveLab +
- Describe the Flashback Technologies
- Managing Undo Automatically
- Employing Flashback Technologies
- Perform Flashback Database Operations
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
09 Diagnosing the Database and Managing Performance 4 topics · 3 LiveLab +
- Diagnosing Failures
- Managing Database Performance
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
10 Managing Database Resources 4 topics +
- Managing Storage
- Managing Storage in a CDB and PDBs
- Summary
- Exam Essentials
11 Creating Oracle Multitenant Databases 4 topics · 2 LiveLab +
- Multitenant Container and Pluggable Database Architecture
- Creating Multitenant Container Databases and Pluggable Databases
- Summary
- Exam Essentials
2 LiveLab in this lesson — see the labs panel →
12 Managing Oracle Multitenant Databases 5 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
13 Oracle Utilities 3 topics · 1 LiveLab +
- Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
- Summary
- Exam Essentials
1 LiveLab in this lesson — see the labs panel →
14 Oracle Security in CDBs and PDBs 3 topics · 6 LiveLab +
- Managing Security in a CDB and PDBs
- Summary
- Exam Essentials
6 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
36 LiveLabs- Creating a Tablespace
- Using UNDO TABLESPACE
- Resizing Data Files
- Putting a Database in ARCHIVELOG Mode
- Executing an Offline Backup
- Recovering the Database from the Loss of All Data Files
- Configuring RMAN
- Creating a Table Using Compression
- Executing an Online Backup of your ARCHIVELOG Mode Database
- Creating a Recovery Catalog Schema
- Restoring your ARCHIVELOG Mode Database with RMAN
- Using the REPORT Command
- Using the LIST Command
- Using the V$SESSION View
- Performing a Tablespace Point in Time Recovery
- Using UNDO_RETENTION
- Purging a Table from the Recycle Bin
- Using Flashback Table
- Setting the Diagnostic Destination
- Using ADRCI
- Managing Initialization-Parameter Files
- Creating a New CDB Using SQL*Plus
- Unlocking the Pluggable Database
- Connecting to a CDB Using SQL*Plus
- Connecting to a PDB Using SQL*Plus
- Displaying the Connection Name
- Unlocking and Connecting to the User Account
- Altering the Session of the Database Container and the Pluggable Database
- Creating a New Pluggable Database
- Using Data Pump to Migrate a Non-CDB to a CDB
- Creating Common and Local Users
- Creating a Database User and Granting Privileges to a User
- Creating and Granting Roles to a User
- Revoking Privileges and Dropping a Role
- Creating a Profile
- Granting the System Privilege
Labs run in your browser — nothing to install.
![1Z0-071.AO1: [ORACLE PRESS] Oracle Database SQL_Image](http://d3hu3i8dxloald.cloudfront.net/images/new/MHE-1Z0-071_pro.png?202608009V)
Prepare for Oracle DB 12c Administrator Certified Professional
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 36 LiveLab included
- Certificate of completion
No credit card required