1Z0-908 study guide
1Z0-908 · Work through your exam, one topic at a time.
The Oracle Database 19c: Administration credential (exam 1Z0-908, often called the OCP 19c DBA) is a professional-level certification for database administrators who run Oracle Database 19c in production. It suits DBAs moving from day-to-day operations toward full ownership of an instance: installation and patching, storage layout, security, backup and recovery, performance work, concurrency and undo, multitenant management, connectivity, and scheduling. The 1Z0-908 study guide has 10 sections and about 3,342 words.
01Architecture and Configuration
The Architecture and Configuration domain checks that you can describe an Oracle 19c instance and database, read V$ views and the alert log, and change configuration without breaking startup. Questions combine memory sizing, background processes and parameter scope.
356 words, about 2 min02Installation and Patching
Installation and Patching tests the mechanics of installing Oracle Database 19c software and applying patches: the installer, root scripts, OPatch, datapatch and the registry views that prove a patch worked. OUI, interactive or silent with a response file, lays down the Oracle home under ORACLE BASE following OFA; DBCA creates databases and NETCA configures the listener.
329 words, about 2 min03Storage Structures and Space Management
Storage Structures and Space Management asks how Oracle maps logical space onto files and how you diagnose extension failures. A tablespace contains segments (table, index, undo, temporary, LOB), segments contain extents, extents contain blocks of db block size (8KB typical, maximum 32KB).
331 words, about 2 min04User Security and Privilege Management
User Security and Privilege Management covers authentication, privileges, roles, profiles and auditing, plus the CDB/PDB distinction in 19c. CREATE USER creates a schema of the same name.
327 words, about 2 min05Backup and Recovery
Backup and Recovery tests the RMAN decision chain: what to back up, how retention interacts, and why restore differs from recover. ARCHIVELOG mode plus a fast recovery area is the baseline for point-in-time recovery.
302 words, about 2 min06Performance Monitoring and Tuning
Performance Monitoring and Tuning focuses on measuring where time goes using AWR, ASH and V$ views, and interpreting waits rather than guessing at parameters. DB time is the time foreground sessions spend in database calls: DB CPU plus non-idle wait time.
352 words, about 2 min07Concurrency, Undo, and Transaction Management
Concurrency, Undo, and Transaction Management covers isolation, locking and the undo machinery that makes read consistency possible. A transaction ends with COMMIT or ROLLBACK; DDL commits implicitly.
341 words, about 2 min08Multitenant Architecture and Pluggable Databases
Multitenant Architecture and Pluggable Databases tests CDB/PDB structure and the administrative tasks that differ from a non-CDB. A CDB contains CDB ROOT, PDB SEED as a read-only template, and one or more PDBs.
348 words, about 2 min09Oracle Net and Connectivity
Oracle Net and Connectivity covers how clients find and connect to a database: naming methods, the listener, and the error codes that identify which link broke. tnsnames.ora maps an alias to a connect descriptor with ADDRESS (PROTOCOL, HOST, PORT) and CONNECT DATA (SERVICE NAME, or SID in older setups).
313 words, about 2 min10Automation, Scheduling, and Data Movement
Automation, Scheduling, and Data Movement tests DBMS SCHEDULER, Data Pump and the loader tools that let routine work run without a person. Objects are programs, schedules, jobs, job classes and chains.
343 words, about 2 min