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
- 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)

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.
What does 1Z0-182 cover?
13 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.
How do I earn this certification?
Passing 1Z0-182 earns the Oracle Database 23ai Administration Certified Associate in the Database Administration track.
How to study for this exam?
Use the 1Z0-182 practice test alongside the official material below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
- Last content update
- May 2, 2024
- Announced
- May 2, 2024
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 simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator