ExamDumpster

1Z0-182

Oracle Database 23ai Administration Associate practice test

524 Oracle 1Z0-182 and 1z0-082 practice questions with explanations, in study, timed and flashcard modes.

Full access

$99

  • All 524 questions across 1Z0-182 and 1z0-082, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Oracle logo
Total questions
524
Free samples
–
Versions
2
Updated
Oct 2026

Exam simulator

Practice 1Z0-182 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

1Z0-182, by the numbers.

Official specifications published by Oracle.

Duration
120 min
Questions
60
Passing score
65%
Exam fee
$245
In the bank
1Z0-182 (203), 1z0-082 (321)
Open the full exam guide

Exam guide

Everything about 1Z0-182.

1Z0-182 · Oracle · v1.0

What is 1Z0-182?

1Z0-182 is an associate exam for people who run Oracle Database 23ai day to day. Passing it earns the Oracle Database 23ai Administration Certified Associate credential. New DBAs, support engineers and data warehouse administrators are the usual candidates. The exam asks you to start and stop databases, manage users and storage, and create pluggable databases. A pluggable database (PDB) is a self-contained database that lives inside a container database. For example, you might choose the Data Pump options that move one schema to another database. The practice test is built around instance management, security, storage and PDBs.

What you'll practise

  • Describe the memory, process and storage structures of an Oracle instance.
  • Start up and shut down databases, and check the Automatic Diagnostic Repository for problems.
  • Create users, roles and privileges, and set up database auditing.
  • Manage tablespaces, data files, segments and undo data.
  • Move data with Data Pump, SQL*Loader and external tables.
  • Create pluggable databases from the seed and change their open modes.

Requirements

  • No formal prerequisites: anyone can book the exam.
  • Recommended: at least a year of hands-on work with Oracle Database.
  • Recommended: basic relational database knowledge and UNIX command skills.
  • Recommended: Oracle's Database 23ai Administration training.

Who it's for

  • Junior database administrators and data warehouse administrators.
  • Support engineers and database designers who need hands-on Oracle skills.
  • DBAs who plan to go on to Oracle's professional-level administration exam.

Exam details

Published by Oracle, plus what is in our question bank.

Duration
120 min
Questions
60
Passing score
65%
Level
Associate

Three ways to practise

Study mode

Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.

Open in the simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

1Z0-182 questions, answered