Classroom in Dharampeth · Live online · One-on-one
Oracle DBA Course in Nagpur Part 1: prepare for 1Z0-082 or 1Z0-182, Oracle’s first DBA exams.
Learn to run an Oracle Database: its architecture and instances, Oracle Net Services, users and security, tablespaces, storage and undo, and moving data. Then take either exam. 1Z0-082 is the first of two exams for Oracle’s 19c Professional credential, and 1Z0-182 earns the Oracle AI Database Administration Certified Associate credential on Oracle’s newest database.
- 1Z0-082 · 19c
- 1Z0-182 · AI Database
- 120 min · online
Taught by Renu NairOracle certified DBA · teaching since 2016
- Oracle Database Administration I
1Z0-08272 questions in 120 minutes, 60% to pass. This course. - Oracle AI Database Administration Associate
1Z0-18260 questions in 120 minutes, 65% to pass. This course. - Oracle Database Administration II
1Z0-08368 questions in 120 minutes, 57% to pass. Part 2 of the course. - Oracle AI Database Administration Professional
1Z0-18365 questions in 120 minutes, 60% to pass. Part 2 of the course.
All four are taken online, proctored by Oracle. From Oracle’s exam pages, read 12 November 2026.
Oracle’s DBA exams
Two ways to start Oracle DBA certification
Both exams test the same core of database administration. 1Z0-082 adds SQL; 1Z0-182 adds pluggable databases, auditing and more.
1Z0-082This courseOracle Database Administration I
Step 1 of Oracle Database Administration 2019 Certified Professional
- 72 questions
- 120 minutes
- 60% to pass
Oracle Database up to and including 19c: SQL, and database and network administration.
1Z0-182This courseOracle AI Database Administration Associate
Earns Oracle AI Database Administration Certified Associate
- 60 questions
- 120 minutes
- 65% to pass
Oracle’s newer entry-level DBA exam, for Oracle AI Database (formerly Oracle Database 23ai). No SQL section.
Where each exam leads
Oracle Database 19c
1Z0-082or1Z0-1821Z0-083
Two exams earn Oracle Database Administration 2019 Certified Professional. Oracle accepts either 1Z0-082 or 1Z0-182 as the first.
Oracle AI Database
1Z0-1821Z0-183
1Z0-182 earns the Associate credential and 1Z0-183 the Professional. Oracle’s 1Z0-183 page lists no exam to pass before it.
From Oracle’s certification list and each exam’s page on Oracle MyLearn, read 12 November 2026. Every exam named here is taken online, proctored by Oracle.
Course syllabus
What the course covers, and which exam tests it
Nine areas are tested by both exams; then 1Z0-082 adds SQL, and 1Z0-182 four areas of its own. Each is practised on a real database.
01Database architectureBoth exams · 1Z0-182: 10%
- Instance configurations
- Memory and process structures
- Logical and physical database structures
- The database server architecture
02Oracle’s own toolsBoth exams · 1Z0-182: 5%
- The Database Configuration Assistant (DBCA)
- Enterprise Manager Cloud Control and Database Express
- SQL Developer and SQL*Plus
03Managing database instancesBoth exams · 1Z0-182: 15%
- Starting up and shutting down an instance
- Data dictionary and dynamic performance views
- The Automatic Diagnostic Repository, the alert log and trace files
- Initialization parameter files
04Oracle Net ServicesBoth exams · 1Z0-182: 5%
- The listener, and connecting to an instance
- Naming methods and the administration tools
- Dedicated and shared server configurations
- Communication between database instances
05Users, roles and privilegesBoth exams · 1Z0-182: 10%
- Users, privileges and roles
- Profiles, and authentication methods
- Quotas, and the principle of least privilege
06Tablespaces and data filesBoth exams · 1Z0-182: 10%
- Creating, altering and dropping tablespaces
- How table data is stored
- Oracle Managed Files
- Moving and renaming data files while they are online
07StorageBoth exams · 1Z0-182: 10%
- Block space management, and the types of segments
- Table and row compression
- Deferred segment creation, and shrinking segments
- Resumable space allocation
08UndoBoth exams · 1Z0-182: 5%
- Transactions and undo data
- Undo retention
- Undo compared with redo, and temporary undo
09Moving dataBoth exams · 1Z0-182: 5%
- External tables
- Oracle Data Pump
- SQL*Loader
10SQL1Z0-082 only · 14 of its 23 topics
- SELECT, restricting and sorting rows, and substitution variables
- Single-row, conversion and group functions
- Joins, subqueries and set operators
- DDL, DML and transactions
- Constraints, temporary tables, views, sequences, synonyms and indexes
- Data in different time zones
DBA work uses SQL every day, so the course teaches it for both exams. Only 1Z0-082 tests it.
11Pluggable databases1Z0-182 only · 10%
- The multitenant container database and its pluggable databases (PDBs)
- Displaying, creating and managing PDBs
12Auditing1Z0-182 only · 5%
- An introduction to database auditing
13Automated maintenance1Z0-182 only · 5%
- The maintenance work the database runs for itself
14Performance1Z0-182 only · 5%
- An introduction to performance
The topic areas are Oracle’s, from the 1Z0-082 and 1Z0-182 exam pages (read 12 November 2026); the percentages are 1Z0-182’s weights, and the lists under each area are how we teach it. Oracle can revise its topics, and the course follows the current lists.
Which exam
1Z0-082 or 1Z0-182: which to take
1Z0-082 Oracle Database 19c
- The exam
- 72 questions in 120 minutes, 60% to pass
- Also tests
- SQL: 14 of its 23 topics
- Leads to
- With 1Z0-083, Oracle Database Administration 2019 Certified Professional
- Suits you if
- You work on Oracle Database 19c, or the job you want does
1Z0-182 Oracle AI Database
- The exam
- 60 questions in 120 minutes, 65% to pass
- Also tests
- Pluggable databases, auditing, automated maintenance and performance
- Earns
- Oracle AI Database Administration Certified Associate, and counts as step 1 of the 19c Professional credential
- Suits you if
- You want Oracle’s newest database, or a credential of its own after one exam
Not sure? Tell us where you work, or want to work, and we will suggest one. The course covers what both exams test.
Fahim A. Jainulabdeen passed 1Z0-082, Oracle Database Administration I, with 91% (pass mark 60%) in August 2020, after training at Unisoft.
From his Oracle score report. The report itself is not shown, because it also prints his Oracle Testing ID and registration number.
The exam
Booking and taking the exam
The exams belong to Oracle. You buy and schedule them on Oracle MyLearn, and take them online, watched by an online proctor. Oracle delivers its exams itself, so these are not among the exams taken at our Pearson VUE centre.
After the exam
- Your result, at onceIt appears on screen at the close of the exam.
- The detailed score reportIt is in Oracle CertView, where you also manage your certifications.
From booking to exam day
- Buy and schedule the exam on Oracle MyLearn. To reschedule, do it at least 24 hours before your appointment.
- Your own computer, meeting Oracle’s minimum system requirements for its online exams.
- A government-issued ID. Oracle requires one to take the exam.
- Check in 30 minutes early. Oracle opens check-in half an hour before the exam time.
The two exams
| Exam | Questions | Pass mark |
|---|---|---|
1Z0-082 Oracle Database Administration I | 72 | 60% |
1Z0-182 Oracle AI Database Administration Associate | 60 | 65% |
Both exams last 120 minutes. Oracle sets the exam price, shown on MyLearn when you buy. From Oracle’s pages for 1Z0-082 and 1Z0-182, read 12 November 2026.
Who it is for
Who the course suits
The course can suit
- Graduates who know SQL
- SQL and PL/SQL developers
- System and support engineers
- DBAs certified on 11g or 12c
Already working with Oracle? Tell us what you know, and we will suggest how much of the course you need.
Where to start
DBA work starts from SQL, and 1Z0-082 tests it. New to SQL? Start with our SQL course.
Oracle recommends a basic understanding of UNIX commands for 1Z0-182, and training with a year of field experience before you take it. Our Red Hat Linux course teaches the Linux side.
Your trainer
Learn from Renu Nair
Renu Nair
Oracle DBA and SQL faculty, Unisoft Technologies
Renu has been teaching since 2016: Oracle databases, SQL and PL/SQL, and the analytics tools built on them. She teaches both parts of the Oracle DBA course, in the Dharampeth classroom, live online and one-on-one. Book a demo class to meet her before you join.
- Database administration
- SQL
- PL/SQL
- Power BI
Oracle certified as a DBA herself
- Oracle Database 12c R2 Administrator Certified AssociateOracle · 30 July 2019
- Oracle Database 12c Administrator Certified ProfessionalOracle · 14 August 2018
- Oracle Database 11g Administrator Certified ProfessionalOracle · 12 January 2018
- Oracle Database 11g Administrator Certified AssociateOracle · 27 December 2016
Issued by Oracle through Credly, where anyone can check them. They are for earlier releases, Oracle Database 11g and 12c; the course teaches 19c and Oracle AI Database. See her badges on Credly
Next step
Book a demo class with Renu
Leave your number and a counsellor will call you to fix a time. Meet Renu in Dharampeth or online.
- Which exam suits you: 1Z0-082 or 1Z0-182
- Meet Renu Nair, who will teach you
- The current fee, duration and next batch, in the classroom, online or one-on-one
Visit us in Dharampeth
Unisoft Technologies, 2nd Floor, Prananand Building, West High Court Road, above Anand Bhandar, opposite Dress Code, Dharampeth, Nagpur 4400104.6 on Google from 1,600+ reviews · Directions and reviews
FAQ
Oracle DBA exam questions, answered
What is the difference between 1Z0-082 and 1Z0-182?
Both test the core of Oracle Database administration: architecture, instances, Oracle Net Services, users, tablespaces, storage, undo and moving data. 1Z0-082, Oracle Database Administration I, also tests SQL, and is the first of two exams for the 19c Professional credential. 1Z0-182, Oracle AI Database Administration Associate, tests pluggable databases, auditing, automated maintenance and performance instead, and earns a credential of its own.
Is 1Z0-082 still available?
Yes. Oracle lists it among its current exams, and its exam page gives no retirement date (read 12 November 2026).
What are the exams like?
Both are multiple choice, taken online in 120 minutes. 1Z0-082 has 72 questions and a 60% pass mark; 1Z0-182 has 60 questions and a 65% pass mark. Your result appears on screen at the end, and the detailed report is in Oracle CertView.
Can I take the exam at Unisoft’s Pearson VUE centre?
No. Oracle delivers these exams itself, proctored online, on your own computer, with a government-issued ID. Our Pearson VUE centre delivers other exams, such as Microsoft, CompTIA, AWS and EC-Council. About our test centre
Does 1Z0-182 count towards the 19c Professional credential?
Yes. For Oracle Database Administration 2019 Certified Professional, Oracle’s 1Z0-083 page lists step 1 as 1Z0-082 or 1Z0-182, and step 2 as 1Z0-083. Part 2 of the course prepares you for 1Z0-083.
Do I need to know SQL?
It helps a great deal. 1Z0-082 tests SQL, and a DBA uses it every day, so the course teaches it. If you are new to SQL, our SQL course is a good place to start.
How do I book the exam?
On Oracle MyLearn, where you buy it and choose a date and time. To reschedule, do it at least 24 hours before your appointment. The exam is bought from Oracle, separately from the course.
Who teaches the course?
Renu Nair, our Oracle DBA and SQL faculty, teaching since 2016. Oracle has certified her as a database administrator on Oracle Database 11g and 12c, at Associate and Professional level. Her profile
Can I study online or one-on-one?
Yes. Batches run in our Dharampeth classroom and live online, and one-on-one sessions are available.
How long is the course, and what does it cost?
That depends on where you start and how you study: in a batch, live online or one-on-one. Send an enquiry or call +91 95030 05060 for the current duration, fee and next batch.
Still have a question? Ask a counsellor about the course, the batches or the fee.