1Z0-182 Verified 2026 Edition

Oracle Database 23ai Administration Associate Practice Test

1Z0-182 earns the Oracle Database 23ai Administration Certified Associate credential, Oracle's current entry point into database administration. It suits administrators building hands-on experience with Oracle Database 23ai. Practice questions here cover database architecture, instance management, user and tablespace administration, and creating pluggable databases.

524 Total Questions
2 Included Versions Get all versions for the price of one
English Edition
$70k–$115k Typical Salary Yearly earnings in the United States for entry-level database administrators, data warehouse administrators and database support engineers, as an estimate.
All-In-One Bundle
$79.99
$75.99
  • Interactive Simulator & AI
  • Detailed Explanations
  • Study, Timed & Flashcard Mode
  • Lifetime Access & Updates

Instant lifetime access • Secure checkout

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

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

120 min
60
65%
Associate

Registration

$245 USD
Pearson VUE or online proctoring
English

Validity

lifetime
Oracle certifications do not expire and remain valid indefinitely; However, it's recommended to upgrade to newer versions as technology evolves

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
Practise these questions in study mode

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

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

Your Complete Exam Solution

Best-In-Class Practice Tests

Exam-style questions that match the format and difficulty of the real exam, updated regularly. Original material — not recycled dumps.

Topical Breakdown

Study by domain, pinpoint weak areas, and focus your time where it matters most. Every topic mapped to the official syllabus.

Flashcard Mode

Rapid-fire review to reinforce key concepts. Flip through questions and answers at your own pace before exam day.

See How You Compare Against Yourself

✕
✕
✕

Other Exam Prep

  • Outdated question dumpsRecycled, often inaccurate material
  • No explanationsMemorize answers without understanding
  • Static PDF filesNo interactive practice or feedback
  • Subscription feesRecurring charges, access expires
✓
✓
✓

PlanetCert

  • Verified, current questionsUpdated weekly to match live exam objectives
  • Expert-written rationalesUnderstand every concept, not just the answer
  • Session tracking & exam progressTrack every attempt, see your growth over time
  • Lifetime access, one pricePay once — updates included forever
CERTIFIED1Z0-182

Study Naturally, Study Responsibly

Practice with exam-style questions and detailed explanations until you're ready.

Try Free Demo
Secure Checkout Lifetime Access