Oracle 1Z0-076 study guide
Oracle 1Z0-076 · Work through your exam, one topic at a time.
The Oracle 1Z0-076 exam is listed by Oracle University under the title "Oracle Database 19c Administration." It is intended for database administrators and technical staff who work with Oracle Database 19c and want a structured, vendor-branded way to demonstrate administration knowledge. This page is an independent study resource and is not affiliated with, endorsed by, or sponsored by Oracle; all exam logistics should be confirmed with Oracle University directly. The Oracle 1Z0-076 study guide has 13 sections and about 3,481 words.
01Oracle Database Architecture
This domain tests the instance/database split, SGA and PGA, background processes, and the logical-to-physical storage map in Oracle 19c. Questions often name a symptom and ask which component owns it.
315 words, about 2 min02Creating and Configuring an Oracle Database
This domain covers database creation with DBCA or CREATE DATABASE, initialization parameters, the server parameter file, and basic network configuration. Expect questions on what can be changed after creation and how clients resolve a service.
288 words, about 1 min03Managing the Oracle Instance
This domain tests startup and shutdown stages, parameter scope, alert-log and ADR use, and instance recovery. Questions often describe a failed startup or a parameter that disappears after restart.
261 words, about 1 min04Managing Database Storage Structures
This domain covers tablespaces, datafiles, segments, extents, blocks, Oracle Managed Files, bigfile tablespaces, and space management. Expect questions on which storage object can be taken offline and how space is allocated.
270 words, about 1 min05Administering User Security
This domain tests users, authentication, privileges, roles, profiles, quotas, and common versus local users in a multitenant database. Expect questions on why a connection or a CREATE TABLE fails.
280 words, about 1 min06Managing Schema Objects
This domain tests tables, constraints, indexes, views, sequences, and synonyms. Questions often ask which object enforces a rule or why a DML statement fails.
286 words, about 1 min07Managing Data and Concurrency
This domain tests transactions, isolation levels, read consistency, locks, and deadlock handling. Expect questions that describe two sessions and ask who blocks whom.
255 words, about 1 min08Managing Undo Data
This domain covers undo tablespaces, undo segments, retention, guarantee, flashback query dependencies, and ORA-01555. Questions often ask why undo cannot be reused or why a query fails.
247 words, about 1 min09Implementing Oracle Database Auditing
This domain tests Oracle 19c unified auditing: policies, enabling, audit trails, and purge jobs. Expect questions on where an audit record is written and how to audit a specific action.
250 words, about 1 min10Performing Database Maintenance
This domain covers routine maintenance: ADR and alert logs, automatic maintenance tasks, optimizer statistics, segment advisor, health checks, and space monitoring. Questions often distinguish a maintenance task from a tuning task.
244 words, about 1 min11Managing Performance
This domain tests performance diagnosis with AWR, ADDM, ASH, SQL tuning, execution plans, and memory advisors. Expect questions on which tool answers which question.
265 words, about 1 min12Backup and Recovery
This domain covers RMAN backup and recovery, archive log mode, the fast recovery area, restore versus recover, and flashback. Questions often describe a lost datafile or an incomplete recovery scenario.
268 words, about 1 min13Moving Data
This domain tests data movement: Data Pump, SQL Loader, external tables, and transportable tablespaces. Expect questions on where dump files are written and how to remap objects.
252 words, about 1 min