Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.

AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Oracle
Exam Format
Registration
Validity
Skills this practice test covers
- Start up and shut down an Oracle database in the right mode for each task.
- Explain why an instance failed to start from its alert log and other Automatic Diagnostic Repository (ADR) files.
- Create users, roles, privileges and profiles that limit what each account can do.
- Create and resize tablespaces and data files, and use Oracle Managed Files.
- Load and unload data with Oracle Data Pump, SQL*Loader and external tables.
- Build PDBs from the seed or by cloning, then change their modes and attributes.
Explore related topics
1Z0-182 exam content
13 domains · 32 topics · 195 of 524 questions are written for 1Z0-182
Describe Oracle Database Architecture10%17 questions
This domain explains what runs when an Oracle database is up. It compares a single instance with Real Application Clusters (RAC), names the memory and process structures, and links logical storage to physical files.
Skills tested
- Tell a single-instance configuration from a RAC configuration.
- Say which work happens in the SGA, which in the PGA, and which in background processes such as DBWn and LGWR.
- Map logical storage, from tablespaces down to blocks, onto the physical data files.
Questions by topic
- Identify Logical and Physical Database Structures9
- Identify Oracle Database Memory and Process Structures8
Employ Oracle supplied Database Tools5%7 questions
Oracle supplies its own tools for daily administration work. Candidates identify and use them, for example SQL*Plus for commands and SQL Developer for browsing database objects.
Skills tested
- Run administrative statements in SQL*Plus.
- Pick the Oracle-supplied tool that suits a given task.
Questions by topic
- Identify and Use the Oracle Supplied Database Tools7
Describe Managing Database Instances15%24 questions
The heaviest domain covers starting, stopping and inspecting an instance. Candidates use startup and shutdown modes, dynamic performance and dictionary views, the Automatic Diagnostic Repository and its logs, and initialization parameter files.
Skills tested
- Start an instance in NOMOUNT, MOUNT or OPEN mode, and choose a shutdown mode.
- Query V$ views and data dictionary views to answer questions about the database.
- Find errors in the alert log and other ADR files.
- Change initialization parameters in a server parameter file or a text parameter file.
Questions by topic
- Demonstrate Startup and Shutdown Procedures for an Oracle Database7
- Use the Automatic Diagnostic Repository (ADR) and Logs7
- Identify and Apply Initialization Parameter Files5
- Utilize System Provided Dynamic Performance and Dictionary Views5
Configuring Oracle Net Services5%12 questions
Clients need a path to the database, and this domain sets it up. Candidates identify the Net Services administration components, such as the listener and naming methods, and describe how connections are made.
Skills tested
- Configure a listener and check that the database registers with it.
- Connect with Easy Connect or with a local naming entry.
- Compare dedicated server and shared server connections.
Questions by topic
- Identify the Net Services Administration Components6
- Describe Net Services Connection Methods6
Managing Users, Roles and Privileges10%13 questions
Security starts with accounts. Candidates set up users, hand out system and object privileges either one by one or bundled in roles, and apply profiles that govern passwords and resource limits.
Skills tested
- Create an account, assign its default tablespace, and limit its space with a quota.
- Grant privileges through roles instead of to each user.
- Apply a profile that locks an account after repeated failed logins.
Questions by topic
- Describe and Utilize User Security Measures for an Oracle Database13
Managing Tablespaces and Datafiles10%12 questions
This domain covers where data is stored. Candidates create, modify and describe tablespaces, and manage data files and their placement, including Oracle Managed Files.
Skills tested
- Create permanent, temporary and undo tablespaces.
- Resize a data file or turn on AUTOEXTEND.
- Let Oracle Managed Files name and place new data files.
Questions by topic
- Recognize and Describe Data Storage and Placement5
- Create, Modify, and Describe Tablespaces7
Managing Storage10%21 questions
This domain goes inside segments and blocks. Candidates explain resumable space allocation, save space with segment compression, and describe segment types, extents and block space management.
Skills tested
- Enable resumable space allocation so that a long operation waits for space instead of failing.
- Compress segments to save space.
- Explain how extents are allocated to segments.
- Describe how free space inside a block is managed.
Questions by topic
- Explain Resumable Space Allocation6
- Identify Requirements for Block Space Management5
- Recognize and Define Segment Characteristics of Storage6
- Describe and Use Segment Space Saving4
Managing Undo5%16 questions
Undo data lets transactions roll back and lets queries see consistent data. Candidates use undo, compare it with redo data, and explain temporary undo.
Skills tested
- Configure an undo tablespace and its retention.
- Explain why undo serves rollback and read consistency while redo serves recovery.
- Explain how temporary undo handles changes to global temporary tables.
Questions by topic
- Explain the Usage of Temporary Undo5
- Apply using Undo Data in an Oracle Database5
- Compare Undo Data and Redo Data6
Moving Data5%18 questions
This domain covers getting data into and out of the database. Candidates use external tables, recognize Oracle Data Pump execution options, and distinguish SQL*Loader commands.
Skills tested
- Query a flat file through an external table.
- Run Data Pump export and import in the right mode with the right parameters.
- Load a file with SQL*Loader and know when Data Pump is the better tool.
Questions by topic
- Distinguish SQL*Loader Commands6
- Explain the usage of External Tables6
- Recognize Oracle Data Pump Execution Options6
Displaying Creating and Managing PDBs10%18 questions
This domain works with the multitenant architecture. A new PDB can come from the seed or from other techniques such as cloning, and each PDB then gets its own open mode and attributes.
Skills tested
- Run CREATE PLUGGABLE DATABASE to build a new PDB from the seed.
- Clone an existing PDB.
- Open and close a PDB and change its attributes.
Questions by topic
- Explain Techniques for Creating PDBs7
- Creating PDBs from the Seed6
- Modify Modes and Attributes for PDBs5
Introduction to Auditing5%16 questions
Auditing answers who did what, and when. The domain covers how database auditing works, how audit policies are created, changed and kept up, and how fine-grained auditing (FGA) and value-based auditing record selected activity.
Skills tested
- Create, enable and drop a unified audit policy.
- Set up fine-grained auditing with the DBMS_FGA package.
- Clean up old records in the audit trail.
Questions by topic
- Create, Modify and Maintain Database Auditing4
- Describe Database Auditing7
- Apply Value Based and FGA5
Automated Maintenance5%6 questions
The database runs some housekeeping jobs on its own in maintenance windows, and this domain covers them. Its topic list on Oracle's page names the value-based and fine-grain auditing objective a second time.
Skills tested
- Describe the automated maintenance tasks, such as collecting optimizer statistics.
- Change when a maintenance window opens and how long it lasts.
Questions by topic
- Describe Automated Database Maintenance6
Introduction to Performance5%15 questions
This domain introduces performance management. Candidates summarize how Oracle manages performance, measure database performance, and describe SQL statement execution, plans, directives and advisors.
Skills tested
- Use DB time and V$ statistics to see where the database spends its time.
- Generate a plan with EXPLAIN PLAN and read its steps in order.
- Explain what the SQL advisors suggest and why the optimizer keeps SQL plan directives.
Questions by topic
- Measure Database Performance6
- Describe SQL Statement Executions, Plans, Directives and Advisors5
- Summarize Oracle Database Performance Management4
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: Oracle's training plus a year or more of hands-on database work.
- Recommended: basic knowledge of relational databases and of UNIX operating system commands.
About the 1Z0-182 exam
Passing 1Z0-182 shows that a new database administrator can create, maintain, secure and monitor an Oracle Database 23ai system. It earns the Oracle Database 23ai Administration Certified Associate certification. The objectives run from instance architecture and Oracle Net Services to users, tablespaces, undo, data movement, pluggable databases (PDBs), auditing and performance.
Describe Managing Database Instances carries the most weight and has the most questions in the PlanetCert practice test: startup and shutdown, dynamic performance and dictionary views, the ADR and parameter files. The explanations name the view, parameter or command behind each answer, which helps when two tools such as Data Pump and SQL*Loader both look right. Flashcard Mode suits the memory structures and view names, from the SGA and PGA to the V$ views. Brainy AI Assistant can compare undo with redo or explain what each PDB open mode allows.
How to earn the certification
- Earns
- Oracle Database 23ai Administration Certified AssociateAssociate
- After
- 1Z0-183 Oracle AI Database Administration Professional
Oracle's professional-level step in database administration after the associate exam.
- 1Z0-184-25 Oracle AI Vector Search Professional
Oracle's professional exam on AI Vector Search, a major feature of the 23ai release.
- 1Z0-183 Oracle AI Database Administration Professional
How to prepare for 1Z0-182
- 1
Set up a container database lab
Set up Oracle Database 23ai in a lab with a container database holding a single PDB. Then add a second PDB from the seed and clone it, so each objective can be tried on a real instance.
- 2
Drill startup, views and the ADR
Describe Managing Database Instances carries the most weight. Start and stop the instance in each mode, query V$ and DBA_ views, and read the alert log after each change.
- 3
Fill a tablespace on purpose
Create and resize tablespaces, then fill one to see resumable space allocation at work. Run an update and a rollback to see what undo stores.
- 4
Move one table three ways
Copy one table out and back in with Data Pump, load the same rows from a CSV file with SQL*Loader, then read that CSV file directly through an external table.
- 5
Finish with timed practice
Work through the 1Z0-182 practice test objective by objective in Study Mode, then sit a full run in Timed Mode. Bring any missed PDB mode or audit policy question to Brainy AI Assistant.
Start a timed 1Z0-182run
On Oracle MyLearn, Oracle recommends one learning path for this exam: Earn the Oracle Database 23ai Administration Associate Credential.
Who 1Z0-182 is for
- Administrators early in their Oracle careers who are responsible for Database 23ai systems.
- Database designers and data warehouse administrators who want a grounding in how Oracle is run day to day.
- Support engineers who troubleshoot Oracle databases for users or customers.
Typical job titles: Database administrator · Junior database administrator · Data warehouse administrator · Database designer · Database support engineer
1Z0-182 glossary
20 terms from the exam objectives and the vendor's official material, each defined in a sentence.
- Alert log
- A log of major events and errors for an instance, in time order, kept in the ADR.
- Automatic Diagnostic Repository (ADR)
- A directory tree on disk where Oracle keeps diagnostic data, such as the alert log, traces and incident packages.
- CDB (Container Database)
- The outer database in the multitenant architecture: it holds the root container, the seed and every PDB, all served by one instance.
- Data Dictionary Views
- Views, grouped by prefixes such as DBA_, ALL_ and USER_, that show the database's own catalog of objects and users.
- Dynamic Performance Views (V$ Views)
- Views whose names start with V$, showing the instance's current state and statistics.
- External Tables
- Tables whose rows are read from files outside the database, so a file can be queried with SQL.
- Fine-Grained Auditing (FGA)
- Auditing driven by a policy condition, for example recording only the queries that touch a sensitive column.
- Oracle Data Pump
- Oracle's export and import utilities, expdp and impdp, for moving data and metadata between databases.
- Oracle Managed Files (OMF)
- The database names its own files, places them in a directory set by a parameter, and deletes them when they are dropped.
- PDB
- A pluggable database: a self-contained set of schemas and data that plugs into a container database.
- Program Global Area (PGA)
- Memory set aside for a single server process and not shared, used for sorts, hash joins and session data.
- Real Application Clusters (RAC)
- An Oracle configuration in which several instances on different servers open the same database.
- Redo Data
- A record of every change, used to recover the database after a failure.
- Resumable Space Allocation
- A feature that suspends an operation that runs out of space, so an administrator can add space before it fails.
- SQL Plan Directives
- Notes the optimizer saves when its estimates were wrong, used to plan similar statements better.
- SQL*Loader
- Oracle's bulk loader for flat files: a control file tells it how each record maps to table columns.
- System Global Area (SGA)
- The shared memory of an instance, holding the buffer cache, shared pool and other areas that all sessions use.
- Temporary Undo
- Undo for global temporary tables that is written to a temporary tablespace, so it generates no redo.
- Undo Data
- The before-images of changed rows, which let a transaction roll back and let other sessions see data as it was.
- Value-Based Auditing
- Auditing that captures the changed values themselves, usually with database triggers.