You can use this Oracle 1Z0-063 exam study guide to collect all the information about the Oracle Database 12c - Advanced Administration exam. The Oracle 1Z0-063 certification exam is mainly targeted to those candidates who have some experience or exposure to Oracle Database 12c technology and want to flourish their career with Oracle Database 12c Administrator Certified Professional (OCP) credential.
The Oracle 1Z0-063 certification exam validates your understanding of the Oracle Database 12c technology and sets the stage for your future progression. Your preparation plan for Oracle Database 12c - Advanced Administration Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following certification exam syllabus topics.
Oracle 1Z0-063 Exam Details:
Exam Name | Oracle Database 12c - Advanced Administration |
Exam Code | 1Z0-063 |
Exam Price | USD $245 (Price may vary by country or by localized currency) |
Duration | 120 minutes |
Number of Questions | 80 |
Passing Score | 60% |
Format | Multiple Choice Questions (MCQ) |
Recommended Training |
Oracle Database 12c Administrator Certified Professional Oracle Database 12c: Backup and Recovery Workshop Oracle Database 12c: Managing Multitenant Architecture |
Schedule Exam | Pearson VUE |
Sample Questions | Oracle Database 12c Administrator Certified Professional (OCP) |
Recommended Practice | 1Z0-063 Online Practice Exam |
Oracle 1Z0-063 Syllabus Topics:
Backup and Recovery |
|
Oracle Data Protection Solutions |
- Explain Oracle backup and recovery solutions
|
Performing Basic Backup and Recovery |
- Back up and recover a NOARCHIVELOG database - Perform backup and recovery in NOARCHIVELOG mode - Use SQL in RMAN |
Configuring for Recoverability |
- Configure and manage RMAN settings
- Configure the Fast Recovery Area
- Configure control files and redo log files for recoverability
|
Using the RMAN Recovery Catalog |
- Create and use an RMAN recovery catalog
- Protect the RMAN recovery catalog
|
Implementing Backup Strategies |
- Use various RMAN backup types and strategies
|
Performing Backups |
- Perform full and incremental backups
- Manage backups
|
Configuring RMAN Backup Options and Creating Backup of Non-Database Files |
- Use techniques to improve backups
- Perform backup of non-database files
|
Using RMAN-Encrypted Backups |
- Create RMAN-encrypted backups
|
Diagnosing Failures |
- Describe the Automatic Diagnostic Workflow
- Handle block corruption
|
Performing Restore and Recovery Operations |
- Describe and tune instance recovery - Perform complete and incomplete recovery
|
Recovering Files Using RMAN |
- Perform recovery for spfile, control file, redo log files - Perform table recovery from backups - Perform recovery of index and read-only tablespaces, temp file - Restore a database to a new host |
Using Oracle Secure Backup | - Configure and use Oracle Secure Backup |
Using Flashback Technologies |
- Describe the Flashback technologies
- Use Flashback to query data
- Perform Flashback Table operations
- Describe and use Flashback Data Archive
|
Using Flashback Database |
- Perform Flashback Database
|
Transporting Data |
- Describe and use transportable tablespaces and databases
|
Duplicating a Database |
- Choose a technique for duplicating a database
|
Monitoring and Tuning of RMAN Operations |
- Tune RMAN performance
|
Managing Pluggable and Container Databases |
|
Multitenant Container and Pluggable Database Architecture |
- Describe the multitenant container database architecture - Explain pluggable database provisioning |
Creating Multitenant Container and Pluggable Databases |
- Configure and create a CDB - Create a PDB using different methods - Unplug and drop a PDB - Migrate a non-CDB database to PDB |
Managing a CDB and PDBs |
- Establish connections to CDB/PDB - Start up and shut down a CDB and open and close PDBs - Evaluate the impact of parameter value changes |
Managing Storage in a CDB and PDBs | - Manage permanent and temporary tablespaces in CDB and PDBs |
Managing Security in a CDB and PDBs |
- Manage common and local users - Manage common and local privileges - Manage common and local roles - Enable common users to access data in specific PDBs |
Managing Availability |
- Perform backups of a CDB and PDBs - Recover PDB from PDB datafiles loss - Use Data Recovery Advisor - Duplicate PDBs using RMAN |
Managing Performance |
- Monitor operations and performance in a CDB and PDBs - Manage allocation of resources between PDBs and within a PDB - Perform Database Replay |
Moving Data, Performing Security Operations and Interacting with Other Oracle Products |
- Use Data Pump - Use SQL*Loader - Audit operations - Use Other Products with CDB and PDBs - Database Vault, Data Guard, LogMiner |
The Oracle Database Advanced Administration Certification Program certifies candidates on skills and knowledge related to Oracle Database 12c products and technologies. The Oracle 1Z0-063 is granted based on a combination of passing exams, training, and performance-based assignments, depending on the level of certification. Oracle Database 12c - Advanced Administration certification is a real benchmark of experience and expertise that helps you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exams, and hands-on experience to prepare for your Oracle Database 12c Administrator Certified Professional (OCP) certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.