Oracle · 1Z0-082

1Z0-082 Exam: Complete Oracle Database Administration Guide

Current 1Z0-082 exam guide covering the two-hour delivery, SQL and database administration topics, official preparation, exam strategy, and career value.

Last verified September 6, 2026

1Z0-082 exam at a glance

Facts last verified September 6, 2026

Domain breakdown

Who should take the 1Z0-082 exam?

1Z0-082 is for aspiring and working Oracle Database administrators who need a structured foundation in SQL and day-to-day database operations. It contributes to Oracle's Database 19c administration credential path and covers both querying data and operating an Oracle instance.

Good candidates understand relational concepts, can work at a command line, and have used a safe Oracle Database lab. The exam expects more than SQL syntax: architecture, memory, processes, storage, users, privileges, connectivity, diagnostics, tools, and data movement are all in scope.

There is no separate exam prerequisite to register for 1Z0-082 in Oracle's current learning path. For the broader professional credential, review all current requirements, including 1Z0-083, inside Oracle MyLearn before planning purchases.

1Z0-082 format, price, and current status

Oracle's current Database 19c administration path still presents Oracle Database Administration I (1Z0-082) as a registrable online certification exam and lists two hours for the exam. Oracle's public English pages do not consistently expose a universal question count, passing threshold, or price without the registration context.

Use the exact details shown in MyLearn for your country, language, and delivery before paying. Do not rely on old articles: Oracle publishes language-specific variants whose question counts and timing can differ, and the storefront has changed over the life of this exam.

Skills measured on 1Z0-082

Oracle does not publish percentage weights for the topic groups, so every item in the official checklist deserves coverage. The exam combines the SQL material administrators use to inspect and manage data with the instance knowledge needed to operate Oracle Database.

SQL query and data manipulation foundations

Write SELECT statements with expressions, aliases, literals, concatenation, DISTINCT, and null handling. Filter rows with correct operators and precedence, sort results, limit rows, and use substitution variables where SQL*Plus workflows require them.

Join tables with inner, outer, self, and non-equijoins. Use single-row subqueries, multiple-row subqueries, and set operators such as UNION, UNION ALL, INTERSECT, and MINUS. Understand column compatibility and how ORDER BY applies to compound queries.

Apply character, number, date, conversion, and conditional functions. Work with CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP, and interval types, and recognize session time-zone effects. Aggregate data with group functions, GROUP BY, and HAVING without creating incorrect results.

Use INSERT, UPDATE, DELETE, and transaction control deliberately. Understand read consistency, commit, rollback, savepoints, locks at an introductory level, and how DDL affects transactions.

Schema and storage objects

Create and manage tables, data types, constraints, views, indexes, sequences, synonyms, and temporary tables. Know which object enforces integrity, accelerates an access path, abstracts a query, or generates values. Understand object dependencies and the effects of common DDL changes.

At the storage level, work with tablespaces, data files, segments, extents, and blocks. Create, alter, drop, move, and inspect tablespaces or files safely. Understand locally managed tablespaces, Oracle Managed Files, online data-file moves, segment shrink, deferred segment creation, and table or row compression where listed.

Undo supports transaction rollback and read consistency. Compare undo with redo, configure retention, inspect undo usage, and understand temporary undo. Storage questions frequently ask for the correct layer: adding a data file is not the same action as reclaiming space inside a segment.

Oracle Database architecture and instances

Understand an Oracle server's instance and database, memory structures, background processes, control files, online redo logs, and data files. Connect the logical model—tablespaces and segments— to physical files without treating them as identical.

Start and stop instances through appropriate modes and understand the state transitions. Work with initialization parameter files, dynamic parameters, data dictionary views, and dynamic performance views. Know when a change applies immediately and when it requires a restart.

Diagnostics include the Automatic Diagnostic Repository, alert log, and trace files. Practice finding evidence for startup, storage, listener, and session problems. A DBA should inspect state and logs before applying a remembered fix.

Users, security, connectivity, and tools

Create and manage users, authentication, system and object privileges, roles, profiles, quotas, and least privilege. Distinguish the ability to connect, create an object, and act on another schema's object. Avoid granting broad administrative roles as a shortcut.

Oracle Net Services connects clients and instances. Configure listeners, service naming, client connections, and appropriate administration tools. Understand dedicated versus shared server at the level needed to choose or troubleshoot a connection design.

The checklist names DBCA, Enterprise Manager Cloud Control, Enterprise Manager Database Express, SQL Developer, and SQL*Plus. Know each tool's purpose and be comfortable with command-line workflows even if a graphical tool performs the same task.

Data movement and administration operations

Use Oracle Data Pump for logical export and import, SQL*Loader for loading external data, and external tables for querying data through database metadata. Compare them by direction, format, scale, transformation need, privileges, and operational goal.

Plan data movement carefully around character sets, schemas, objects, dependencies, storage, and security. Validate row counts and errors after loading rather than assuming a completed job means the target is correct.

How to prepare for 1Z0-082

Install or access a legal Oracle Database 19c lab. Create a database or training instance, connect through SQL*Plus, create users and tablespaces, manage objects, load sample data, and query dynamic views. Keep a command journal with the expected state before and after each operation.

Practice failure and recovery within the exam's scope: an unavailable tablespace, exhausted quota, bad privilege, listener problem, invalid object, failed load, or incorrect transaction. Read the error and diagnostic source before changing configuration.

Use Oracle's topic list as a checklist and the Database 19c documentation as the authority. Review the full credential path in MyLearn and confirm the live registration details before exam day.

1Z0-082 practice questions

Good questions ask what a command changes, which view supplies evidence, which privilege is least sufficient, or which tool fits a movement task. Run the scenario in a disposable lab and explain why each alternative is wrong.

Avoid dumps or claims of live questions. They undermine exam integrity and do not prepare you to administer a database where version, state, and consequences matter.

1Z0-082 compared with 1Z0-071 and 1Z0-083

1Z0-071 focuses on Oracle Database SQL. 1Z0-082 combines SQL foundations with Administration I, while 1Z0-083 advances into installation, upgrade, backup and recovery, multitenant, and related professional administration. Oracle's current path does not require 1Z0-071 before the DBA exams.

Career value of 1Z0-082

The exam supports junior Oracle DBA, database support, application support, and operations roles. It provides a useful vocabulary and operational base, particularly in organizations running Oracle Database 19c.

Pair it with evidence of backup and restore drills, patch planning, monitoring, SQL troubleshooting, and automation as you progress. Production judgment matters more than command recall.

Exam-day notes

• Oracle's current Database 19c path lists the online exam as two hours.
• Confirm question count, passing requirement, price, and delivery in MyLearn at registration.
• Practice without external materials unless the registration policy explicitly permits them.
• Read commands for destructive effects and implicit commits before choosing an answer.
• Verify the full certification-path requirements, not only the exam status.

Prep resources

← More Oracle exams