Oracle DBA study guide
Oracle DBA · Work through your exam, one topic at a time.
The Oracle Database Administration I exam, listed by Oracle University under the code 1Z0-082, is the first of the two associate-level administration exams on the Oracle Database 19c administration track. It targets working database administrators, systems engineers, and technical consultants who already touch Oracle Database in production or lab environments and want a structured, vendor-recognised validation of day-to-day administration skill. The Oracle DBA study guide has 10 sections and about 3,317 words.
01Oracle Database Architecture
An Oracle instance is memory plus background processes; the database is the set of physical files (datafiles, control file, redo log files, plus the parameter and password files). One database is normally opened by one instance; many instances can run on one host.
322 words, about 2 min02Create an Oracle Database Instance
DBCA is the supported, scriptable path and is expected in most hands-on tasks; CREATE DATABASE is the manual path that reveals what DBCA hides - writing the parameter file, starting NOMOUNT, running the CREATE DATABASE statement, then catalog.sql, catproc.sql and pupbld.sql. A PFILE is a text file (init<SID .ora) read at startup.
344 words, about 2 min03Configuring the Oracle Network Environment
A client connection needs an address (host, port, protocol) and a service name . Listener configuration lives in listener.ora on the database server; client-side name resolution lives in tnsnames.ora (local naming) or is derived at connect time by Easy Connect ( host:port/service ).
325 words, about 2 min04Create and Manage Database Storage Structures
Database → tablespaces → segments → extents → blocks; each tablespace maps to one or more datafiles . Every database needs SYSTEM (data dictionary), SYSAUX (AWR, OEM repository, components), an undo tablespace and a TEMP tablespace.
334 words, about 2 min05Administering User Security
IDENTIFIED BY password (or EXTERNALLY, or GLOBALLY AS directory name) with a default tablespace , temporary tablespace , profile and quota . A user can log in with CREATE SESSION, but cannot own a segment in a tablespace without a quota or UNLIMITED TABLESPACE.
335 words, about 2 min06Managing Data Concurrency
A transaction begins with its first DML and ends with COMMIT, ROLLBACK or an implicit commit from DDL. Oracle provides statement-level read consistency under READ COMMITTED using undo: readers never wait for writers and writers never wait for readers, because a query reads the SCN-consistent image of each block from undo.
313 words, about 2 min07Implementing Oracle Database Auditing
From 12c, Oracle writes all audit records into a single unified audit trail owned by AUDSYS and exposed through UNIFIED AUDIT TRAIL . New databases have unified auditing enabled by default.
354 words, about 2 min08Backup and Recovery Concepts
In NOARCHIVELOG mode filled redo logs are overwritten, so the only valid backups are consistent ones taken after a clean shutdown. Recovery is restore-only and everything since the backup is lost.
337 words, about 2 min09Managing Undo Data
Undo holds before-images used for rollback , read consistency and instance recovery . Each transaction writes to one undo segment inside the undo tablespace.
314 words, about 2 min10Moving Data
Data Pump ( expdp / impdp ) runs on the server : the job executes inside the database and writes its dump file to a server-side DIRECTORY object, so the user needs READ/WRITE on that directory and the path must exist on the server. Key options: SCHEMAS, TABLES, CONTENT=METADATA ONLY DATA ONLY, INCLUDE/EXCLUDE, REMAP SCHEMA, REMAP TABLESPACE, PARALLEL, ESTIMATE, FLASHBACK SCN/FLASHBACK TIME for consistency, SQLFILE to emit DDL, and NETWORK LINK to copy directly between databases with no dump file at all.
339 words, about 2 min