Oracle 1Z0-078 study guide
Oracle 1Z0-078 · Work through your exam, one topic at a time.
The Oracle Database 12c Advanced Administration credential (exam 1Z0-078) is aimed at working database administrators who already handle day-to-day operations and want to demonstrate depth in the areas that separate a junior DBA from a senior one: recovery under pressure, diagnosing performance problems, and running a multitenant estate. The exam assumes familiarity with instance and storage architecture rather than teaching it, and it tests whether you can choose the right mechanism and predict its consequences. The Oracle 1Z0-078 study guide has 7 sections and about 2,789 words.
01Database Architecture and Configuration
This domain checks whether you can describe how an Oracle Database 19c instance is assembled from memory and background processes, how it attaches to a database, and how configuration decisions (parameter scope, SGA/PGA sizing, container-level parameters) change runtime behaviour. An instance is the SGA plus background processes; a database is the physical files (data files, control files, redo logs, and in 19c a server parameter file).
375 words, about 2 min02Backup and Recovery
This domain tests RMAN-based protection: archivelog mode, backup types and strategies, retention policy, restore versus recover, incomplete recovery, and the flashback features that shorten recovery. Online consistent backups and point-in-time recovery require ARCHIVELOG mode, enabled from the MOUNT stage with ALTER DATABASE ARCHIVELOG.
401 words, about 2 min03Performance Tuning and Diagnostics
This domain covers the Oracle diagnostic infrastructure - AWR, ADDM, ASH, wait-event analysis, SQL advisors and plan management - and whether you can read a workload report and act on it correctly. DB time is the cumulative time foreground sessions spend in the database, CPU plus wait.
398 words, about 2 min04Storage and Space Management
This domain tests logical and physical storage: tablespace and segment structures, space allocation and reclamation, undo and temporary space, and Automatic Storage Management disk groups. Hierarchy: tablespace segment extent Oracle block.
423 words, about 2 min05Managing Multitenant Architecture
This domain tests the container database model: how root, seed and pluggable databases relate, how users and objects are scoped, and how PDBs are created, cloned, unplugged, opened and governed. A CDB contains CDB ROOT, PDB SEED (read-only template, never opened read-write), optional application root and application PDBs, and ordinary PDBs.
393 words, about 2 min06Managing Data Movement and Replication
This domain covers moving data between databases with Data Pump, SQL Loader, external tables and transportable tablespaces, plus the GoldenGate model for ongoing replication. expdp and impdp run as server-side jobs.
392 words, about 2 min07Security and Auditing
This domain tests how access is controlled and recorded: authentication paths, privilege and role behaviour, profiles, encryption and redaction, and the unified auditing framework. Privileged connections (SYSDBA, SYSOPER) authenticate through a password file with REMOTE LOGIN PASSWORDFILE=EXCLUSIVE; the OS group (OSDBA) allows local OS authentication.
407 words, about 2 min