Every organisation running Oracle needs people who can keep the database healthy, available, and correctly configured, and that work does not happen by itself. The 1Z0-182 exam, Oracle AI Database Administration Associate, certifies the core competence of an Oracle DBA on the current 23ai database: managing instances, users, storage, and the multitenant architecture that modern Oracle deployments rely on.
The exam is broad and practical, covering thirteen domains that map to the daily responsibilities of a database administrator. Managing database instances carries the most weight, but the marks are spread widely, so no area can be ignored. This guide groups the thirteen domains into themes and sets out a study plan matched to the weightings.
Table of Contents
- What Does the Oracle 1Z0-182 Exam Cover?
- Who Should Take the Oracle AI Database Administration Certification?
- What Database Architecture and Instance Management Must You Know?
- How Does the Exam Approach Users, Roles, and Auditing?
- What Storage, Tablespace, and Undo Knowledge Is Required?
- What Do Multitenant PDBs Require?
- How Are Net Services, Data Movement, and Maintenance Tested?
- What Careers Does the Certification Support?
- How Should You Structure a 1Z0-182 Study Plan?
- Frequently Asked Questions
- Conclusion
What Does the Oracle 1Z0-182 Exam Cover?
The Oracle 1Z0-182 (Oracle AI Database Administration Associate) is a 120-minute exam of 60 multiple-choice questions with a passing score of 65 percent and a fee of $245 USD. It validates the core skills of an Oracle database administrator on the 23ai database, spanning instance management, security, storage, and the multitenant architecture.
How Is the Exam Structured?
The exam is defined by thirteen weighted domains, with Managing Database Instances the largest at 15 percent and most others between 5 and 10 percent. That spread means the exam rewards broad, rounded competence rather than deep focus on any single topic, and a study plan should cover the full administrative surface of the database.
Domain Weightings at a Glance
| Domain | Weight |
|---|---|
| Managing Database Instances | 15% |
| Database Architecture | 10% |
| Managing Users, Roles and Privileges | 10% |
| Managing Tablespaces and Datafiles | 10% |
| Managing Storage | 10% |
| Managing PDBs | 10% |
| Database Tools, Net Services, Undo, Moving Data | 5% each |
| Auditing, Automated Maintenance, Performance | 5% each |
Read the weightings before studying. Instance management leads, and the four 10 percent domains, architecture, users, tablespaces, storage, and PDBs, form the bulk of the exam. Together these account for most of the marks and should anchor your preparation.
Who Should Take the Oracle AI Database Administration Certification?
The 1Z0-182 is aimed at aspiring and junior database administrators, and at developers or system administrators who manage Oracle databases as part of a broader role. It is the associate-level foundation of the Oracle DBA path, suited to those establishing formal, certified competence with the platform.
What Background Helps
Familiarity with SQL and basic database concepts makes the exam far more approachable, since administration builds on understanding how the database stores and retrieves data. Hands-on exposure to an Oracle database is close to essential. Those exploring the wider Oracle certification landscape often review adjacent credentials, and this Oracle 1Z0-1052 preparation guide shows how the Oracle exams are structured.
Where It Fits
As the associate DBA credential, the 1Z0-182 establishes the foundation that professional-level Oracle certifications assume. It validates that you can perform core administration confidently, and it complements the broader Oracle portfolio. This look at the Oracle 1Z0-1110 certification shows how Oracle credentials build toward specialised roles.
Once you know the blueprint, put it to work with a full 1Z0-182 practice exam to benchmark your readiness under real conditions.
What Database Architecture and Instance Management Must You Know?
Database Architecture (10%) and Managing Database Instances (15%) are the technical heart of the exam. Together they cover how an Oracle database is structured and how the administrator controls the running instance, which is the foundation of every other administrative task.
Oracle Database Architecture
The exam expects you to understand the components of an Oracle database and instance: memory structures, background processes, and the physical and logical storage that hold the data. Knowing how these fit together is prerequisite to managing them. The Oracle Database concepts guide is the authoritative reference for this architecture.
Managing Instances
Instance management, the largest domain, covers starting and stopping the database, managing initialisation parameters, and the tools used to administer the instance. The exam expects command of how the instance is controlled day to day, since this is the most frequent administrative activity and the one most likely to affect availability.
How Does the Exam Approach Users, Roles, and Auditing?
Managing Users, Roles and Privileges (10%) and Introduction to Auditing (5%) address who can access the database and how their actions are tracked. Together they form the security-adjacent core of database administration, ensuring access is controlled and accountable.
Users, Roles, and Privileges
The exam expects command of creating and managing users, granting privileges directly and through roles, and applying the principle of least privilege. Understand the difference between system and object privileges and how roles simplify administration at scale. The Oracle Database security guide covers how these controls work in practice.
Auditing
The auditing domain introduces how database activity is recorded for accountability and compliance. Understand the basics of configuring auditing and why it matters, since a record of who did what is essential both for security and for troubleshooting. Though only 5 percent, it complements the access-control content.
What Storage, Tablespace, and Undo Knowledge Is Required?
Three storage-related domains, Managing Tablespaces and Datafiles (10%), Managing Storage (10%), and Managing Undo (5%), cover how the database organises and manages the data it holds. Together they are a substantial part of the exam and central to keeping a database healthy.
Tablespaces, Datafiles, and Storage
The exam expects command of the logical storage of tablespaces and the physical storage of datafiles, and how they relate. Understand creating and managing tablespaces, monitoring space, and the storage structures that underpin them, since running out of space is one of the most common and disruptive database problems.
Undo Management
Undo management covers how Oracle maintains the information needed to roll back transactions and provide read consistency. Understand how undo is managed and why correct sizing matters, since undo problems affect both transaction integrity and query behaviour. It is a focused but important topic.
“Oracle Database 23ai is a game changer for enterprises worldwide, and because of the importance of the breakthrough AI technology in this release, we are renaming it to Oracle Database 23ai.”
What Do Multitenant PDBs Require?
Managing PDBs, worth 10 percent, covers the multitenant architecture that is now central to Oracle. It addresses displaying, creating, and managing pluggable databases within a container database, which is how modern Oracle consolidates and manages many databases efficiently.
The Multitenant Architecture
The exam expects understanding of the container and pluggable database model: how a CDB hosts multiple PDBs, and how PDBs are created, opened, closed, and moved. This architecture is fundamental to current Oracle deployments, and administrators are expected to be fluent in it rather than treating it as optional.
Managing Pluggable Databases
Beyond concepts, the domain covers the practical management of PDBs: provisioning them, monitoring their state, and understanding how they share and isolate resources within the container. Because consolidation through multitenancy is now standard practice, this domain reflects real day-to-day Oracle administration.
For a related path, see our guide to the Oracle 1Z0-1110 certification.
How Are Net Services, Data Movement, and Maintenance Tested?
Several focused domains at 5 percent each round out the exam: Configuring Oracle Net Services, Moving Data, Automated Maintenance, Database Tools, and Introduction to Performance. Individually small, together they cover the connectivity, data handling, and upkeep that complete an administrator’s toolkit.
Connectivity and Data Movement
Oracle Net Services covers how clients connect to the database, including listeners and connection configuration. Moving Data covers the tools for exporting, importing, and loading data. The exam expects awareness of how connectivity is established and how data is moved efficiently between environments.
Maintenance and Performance
Automated Maintenance covers the tasks Oracle performs automatically to keep the database healthy, while Introduction to Performance provides a first look at monitoring and tuning. Understand what the automated maintenance tasks do and the basics of identifying performance issues, since these connect administration to the reliability the business depends on.
What Careers Does the Certification Support?
The 1Z0-182 maps most directly to junior database administrator, database operator, and associate DBA roles in organisations running Oracle. It signals verified, foundational competence with Oracle administration, which is directly valuable given how widely Oracle databases underpin enterprise systems.
A Foundation for a DBA Career
Its value is as the recognised starting point of the Oracle DBA path. The skills, instance management, security, storage, and multitenancy, are the daily work of the role and transfer directly into practice. As an associate credential, it also prepares candidates for the professional-level Oracle certifications that follow.
Registration
The exam is scheduled through Pearson VUE’s Oracle programme, at a test centre or online with a proctor. Confirm current requirements when you book, since Oracle updates its certification portfolio and exam versions periodically.
“Searches on a combination of business and semantic data are easier, faster, and more precise if both types of data are managed by a single database.”
How Should You Structure a 1Z0-182 Study Plan?
Eight to ten weeks at eight to ten hours per week suits most candidates with some database exposure, and longer for newcomers. Because the exam is practical, hands-on time in an Oracle database, whether a local installation or a cloud free tier, matters more than reading, and the plan should cover all thirteen domains proportionally.
A Ten-Week Sequence
- Weeks one to two – architecture and instances. Learn the database architecture and practise starting, stopping, and managing the instance.
- Weeks three to four – users and security. Work through users, roles, privileges, and auditing.
- Weeks five to six – storage. Cover tablespaces, datafiles, storage, and undo management.
- Weeks seven to eight – multitenancy. Create and manage PDBs within a container database.
- Weeks nine to ten – operations and review. Cover net services, data movement, maintenance, and performance, then move to timed practice.
The Habit That Separates Passes From Retakes
Administer a real database. A candidate who has created users, managed tablespaces, and plugged in a PDB answers the practical questions with confidence, while one who has only read struggles with the operational detail. Working through a full 1Z0-182 practice exam under timed conditions also reveals which of the thirteen domains you have under-covered.
Frequently Asked Questions
How many questions are on the 1Z0-182 exam?
The exam contains 60 multiple-choice questions to be completed in 120 minutes. That leaves comfortable time per question, though the breadth of thirteen domains means preparation must be wide.
What is the passing score for the 1Z0-182 exam?
The passing score is 65 percent. Because the questions sample across thirteen domains, consistent coverage of the whole syllabus matters more than depth in a few.
How much does the 1Z0-182 exam cost?
The exam fee is $245 USD, though pricing varies by country and currency. It is booked through Pearson VUE as part of Oracle’s certification programme.
What database version does the exam cover?
The exam covers Oracle Database administration on the current 23ai release. The “AI” in the name refers to the database version rather than to artificial intelligence administration.
Which domain carries the most weight?
Managing Database Instances at 15 percent is the largest domain. The 10 percent domains, architecture, users, tablespaces, storage, and PDBs, together form the bulk of the remaining marks.
Are there prerequisites for the 1Z0-182?
There are no formal prerequisites, but familiarity with SQL and basic database concepts is effectively expected. Hands-on exposure to an Oracle database makes the exam considerably more approachable.
What are PDBs?
PDBs are pluggable databases within Oracle’s multitenant architecture. A container database hosts multiple pluggable databases, and managing them is a 10 percent domain reflecting how central multitenancy is to modern Oracle.
Is hands-on practice necessary?
Effectively yes. The exam is practical, and administering a real database, creating users, managing storage, and working with PDBs, translates far better than reading documentation alone.
What jobs can the certification support?
It maps to junior database administrator, database operator, and associate DBA roles in organisations running Oracle, and it is the recognised entry point to the Oracle DBA career path.
How long does it take to prepare for the 1Z0-182?
Eight to ten weeks at eight to ten hours per week is realistic for candidates with some database exposure. Newcomers should plan for longer and prioritise hands-on administration practice.
Conclusion
The Oracle 1Z0-182 is the recognised foundation of the Oracle DBA path, certifying the core administrative competence that every Oracle environment needs. Its thirteen domains map to the real work of a database administrator, from instance management and security through storage to the multitenant architecture that defines modern Oracle.
Ground your preparation in a live database, because the exam rewards hands-on administration over memorised commands. Anchor your study in the largest domains, instance management and the 10 percent areas, while giving the smaller operational domains enough attention to secure their marks.
Plan eight to ten weeks, cover all thirteen domains proportionally, and administer a real database throughout. The 1Z0-182 validates genuine entry-level DBA competence, and it opens the database administration roles where keeping Oracle running well is a business-critical responsibility.
