Oracle Database Administration I study guide
Oracle Database Administration I · Work through your exam, one topic at a time.
Oracle Database Administration I is the foundational certification exam for working database administrators and for developers, system administrators, and support engineers who are moving into day-to-day database operations. It tests whether you can run an Oracle database instance and keep it healthy: how the instance and database architecture fit together, how storage is allocated and monitored, how users and privileges are managed, how the database is created and started or stopped, how schema objects and data are maintained, how undo and redo support transactions and recovery, how backup, recovery, and flashback work at a conceptual and practical level, how clients connect through Oracle Net, and how to read the built-in performance and diagnostic tooling. The Oracle Database Administration I study guide has 10 sections and about 3,703 words.
01Oracle Database Architecture and Instance Management
This domain tests whether you can describe an Oracle instance's memory and process architecture precisely enough to predict how a configuration change behaves. Expect questions on SGA components, the PGA, background processes, and the boundary between an instance and a database.
389 words, about 2 min02Database Storage Structures and Space Management
This domain tests the logical-to-physical storage hierarchy and the diagnostic queries that explain why a segment cannot grow. Most questions reduce to a symptom such as ORA-01653 or ORA-01652 and the view that proves the cause.
381 words, about 2 min03Managing Users, Privileges, and Profiles
This domain tests user creation and the privilege model: system versus object privileges, roles, quotas, and the profile limits that control resources and password behavior. CREATE USER names an authentication method (password, BY VALUES, EXTERNALLY, GLOBALLY), a default tablespace, a temporary tablespace, a profile, and optional quotas.
379 words, about 2 min04Database Creation, Startup/Shutdown, and Configuration
This domain tests how a database is created and how it moves through startup and shutdown states, including which file is read at each stage and which failures map to which stage. You create a database with DBCA or a CREATE DATABASE script, optionally using Oracle Managed Files through DB CREATE FILE DEST.
366 words, about 2 min05Schema Objects and Data Management
This domain tests the objects you create and the DDL and DML behavior around them: tables and data types, constraints, indexes, views, sequences, synonyms, temporary tables, and partitioning basics. A heap table stores rows unordered; an index-organized table stores rows in the primary key index.
345 words, about 2 min06Undo, Redo, and Transaction Management
This domain tests how Oracle guarantees read consistency and durability: undo for before-images, redo for durability, and the transaction semantics that link them. Undo records before-images and serves rollback, read consistency, and Flashback Query.
383 words, about 2 min07Backup, Recovery, and Flashback Fundamentals
This domain tests the difference between protecting a database and rewinding it: backup types, ARCHIVELOG implications, RMAN operations, and the several distinct Flashback technologies, each backed by a different mechanism. Physical backups are taken with RMAN or user-managed OS commands; logical backups use Data Pump.
360 words, about 2 min08Oracle Net Services and Connectivity
This domain tests how a client finds and connects to a database: name resolution, listener registration, and the error codes that tell you which layer failed. The client resolves a connect identifier using the methods and order listed in NAMES.DIRECTORY PATH in sqlnet.ora.
351 words, about 2 min09Performance Monitoring and Advisory Framework
This domain tests the built-in instrumentation: dynamic performance views, the Automatic Workload Repository, ADDM, Active Session History, and the advisors that interpret the collected data. V views are dynamic performance views built on X fixed tables in memory; GV views add RAC instance columns.
395 words, about 2 min10Diagnostic Tools and Automated Maintenance
This domain tests where diagnostic output lives and how Oracle runs maintenance jobs for you: the Automatic Diagnostic Repository, trace and incident files, health checks, and the automated maintenance task framework. Since 11g, diagnostics live under DIAGNOSTIC DEST, typically ORACLE BASE/diag/rdbms/<db name /<instance /, with alert, trace, incident, cdump, and hm subdirectories.
354 words, about 2 min