1Z0-082

Oracle Database Admin I 1Z0-082 practice exams

290 questions in 5 timed practice tests. Each test has about 60 questions and a 100-minute limit. The pass mark is 60%. Results are split across the 8 exam domains.

Exam at a glance

1Z0-082 practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 60
Time limit per test 100 minutes
Pass mark 60%
Question types Single answer and multiple answer (22 multiple-answer questions)
Level Associate
Category Data & Analytics

These are the settings of our practice tests. Check the official Oracle exam page for the current exam format before you book.

Domains and weights

1Z0-082 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Oracle Database Architecture and Instance Management 16% 46
Oracle Net Services and Database Tools 8% 23
Users, Roles, Privileges and Profiles 10% 29
Tablespaces, Storage, Space and Undo Management 16% 46
Moving Data with SQL*Loader, Data Pump and External Tables 7% 20
SQL Retrieval, Restriction, Sorting and Single-Row Functions 15% 44
Aggregation, Joins, Subqueries and SET Operators 14% 41
DML, Transactions, DDL and Schema Objects 14% 41

Sample questions

Question 1 of 3

Users report that a query on V$SESSION from a PDB shows only sessions for that PDB, but the DBA wants to see all sessions in the CDB along with the container each belongs to. What should the DBA do?

  1. A Query V$SESSION from the PDB with the CONTAINERS clause enabled for every session row in the CDB
  2. B Connect to PDB$SEED, because the seed exposes session rows for all pluggable databases in the CDB
  3. C Set the CONTAINER parameter to ALL in the PDB session and query DBA_USERS to list active sessions
  4. D Connect to CDB$ROOT as a common user with the needed privileges and query V$SESSION, using the CON_ID column (correct answer)
Why: When queried from the root, V$ views show rows for all containers, and the CON_ID column identifies each one. Within a PDB, the view is limited to that container. The CONTAINERS clause is used with tables and views in application or common contexts, not by enabling it per session row. There is no CONTAINER=ALL session setting, and DBA_USERS lists users, not sessions. PDB$SEED cannot be used for normal queries of this kind.

Question 2 of 3, choose 2

Which two statements about the database writer process are true? (Choose two.)

  1. A It must finish writing all dirty buffers before LGWR can write the redo
  2. B It writes every modified buffer immediately at commit to guarantee durability
  3. C It can write uncommitted changes to data files, because undo protects them (correct answer)
  4. D It only writes blocks that belong to tables, never index or undo blocks
  5. E It writes dirty buffers when a checkpoint occurs or free buffers are scarce (correct answer)
Why: DBWn may write blocks containing uncommitted changes, because the related undo and redo allow them to be rolled back. It writes dirty buffers on checkpoints, when free buffers are scarce and at other triggers. Durability at commit comes from LGWR, not DBWn writing blocks. The write-ahead rule requires redo to be written before the matching data block, not the reverse. DBWn writes table, index and undo blocks alike.

Question 3 of 3, choose 2

Which two statements about the shared server architecture in Oracle Database 19c are true? (Choose two.)

  1. A Setting SHARED_SERVERS to a value greater than zero enables shared server even if DISPATCHERS is not set (correct answer)
  2. B Each dispatcher can serve only one client connection at a time, so one dispatcher is needed per session
  3. C Enabling shared server always requires an instance restart because SHARED_SERVERS is a static parameter
  4. D Shared server and dedicated server connections can coexist in the same instance at the same time (correct answer)
  5. E SYSDBA connections must go through a dispatcher once shared server has been enabled for the instance
Why: Shared server is enabled by setting SHARED_SERVERS above zero, and Oracle creates a default TCP dispatcher if DISPATCHERS is not set. Dedicated and shared connections can run side by side. SHARED_SERVERS is dynamic, so no restart is needed. Administrative SYSDBA connections use dedicated servers. A dispatcher multiplexes many client connections, which is the point of the architecture.

What your score report looks like

Example attempt, 1Z0-082 practice test 3

75%

Passed
Pass mark 60%

Score by exam domain
DomainWeightYour score%
Oracle Database Architecture and Instance Management 16%
88
Oracle Net Services and Database Tools 8%
81
Users, Roles, Privileges and Profiles 10%
76
Tablespaces, Storage, Space and Undo Management 16%
58
Moving Data with SQL*Loader, Data Pump and External Tables 7%
84
SQL Retrieval, Restriction, Sorting and Single-Row Functions 15%
72

Study next: Tablespaces, Storage, Space and Undo Management. It is below the pass mark and carries 16% of the exam.

Domains and pass mark from our 1Z0-082 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Oracle Database Architecture and Instance Management and Tablespaces, Storage, Space and Undo Management, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the 1Z0-082 practice exams

Are these real 1Z0-082 exam questions?
No. We write every question ourselves and map it to the published 1Z0-082 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Oracle. 1Z0-082 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
1Z0-083Oracle DBA II 1Z0-083 Oracle Professional 300 110 $14.99
1Z0-1072-26OCI Architect Associate 1Z0-1072-26 Oracle Professional 300 90 $14.99
1Z0-1158-26Oracle Cloud Infrastructure Enterprise AI Pro 1Z0-1158-26 Oracle Professional 250 90 $14.99
1Z0-149Oracle Database PL/SQL Developer Pro 1Z0-149 Oracle Professional 300 90 $14.99
1Z0-997-26OCI Architect Professional 1Z0-997-26 Oracle Professional 300 90 $14.99
1Z0-1085-26OCI Foundations 1Z0-1085-26 Oracle Foundational 200 60 $9.99