Oracle Database Administration II (1Z0-083) Practice Test

While the 1Z0-082 exam focuses on foundational administration tasks for a single non-CDB instance (installation, basic security, backup/recovery, performance fundamentals), the 1Z0-083 is an advanced exam centered on Oracle's multitenant architecture. It delves deeply into managing Container Databases (CDBs) and Pluggable Databases (PDBs), along with advanced topics like sophisticated RMAN recovery scenarios, Oracle Data Guard configuration in a CDB environment, advanced security (including Unified Auditing), and using Oracle Resource Manager to control resources between PDBs. It assumes knowledge from DBA I and builds upon it for complex, enterprise deployments.

Oracle officially recommends at least 1-2 years of hands-on experience with Oracle Database administration, specifically with Oracle Database 12c, 18c, or 19c in a multitenant environment. However, given the advanced nature of the topics, most successful candidates have 3+ years of practical experience. This should include direct work with CDB/PDB lifecycle management (creation, cloning, relocation), implementing backup and recovery strategies using RMAN for multitenant databases, and exposure to performance tuning, security configuration, and high-availability setups like Data Guard.

Yes, Oracle Data Guard is a critical component of the 1Z0-083 exam blueprint. You must understand how to configure, manage, and monitor Data Guard broker configurations in a multitenant environment. This includes tasks specific to CDBs and PDBs, such as creating standby databases for a CDB, performing role transitions (switchover/failover), and managing PDBs within a Data Guard configuration. Questions will test your ability to implement this core high-availability and disaster recovery solution.

Oracle Resource Manager is a key topic for managing performance and resource allocation in a multitenant architecture. For the exam, you need to understand how to create and manage resource plans to control CPU, parallel server, and I/O utilization between different PDBs within a single CDB. This includes creating CDB resource plans, defining shares and utilization limits for PDBs, and setting directives for specific consumer groups. ORM is crucial for ensuring predictable performance and preventing any one PDB from monopolizing CDB resources.

The exam covers RMAN operations at both the CDB and PDB level. You must know how to perform complete and incomplete recovery of a CDB, the root, and individual PDBs. Key concepts include using the `RMAN> ALTER PLUGGABLE DATABASE ... RECOVER` command, performing tablespace point-in-time recovery (TSPITR) for a PDB, and understanding the implications of backup and recovery operations in a multitenant environment, such as which files are affected and how to restore and recover specific PDBs without affecting others.