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 instance, then read the alert log and trace files.
- Grant privileges through roles, set tablespace quotas and assign profiles to users.
- Create and alter tablespaces, and move or rename a data file while it stays online.
- Configure undo retention and explain how undo data differs from redo data.
- Set up the Oracle Net listener and resolve connections with a naming method.
- Write queries with joins, subqueries, group functions and set operators.
Explore related topics
1z0-082 exam content
10 domains · 44 topics · 225 of 524 questions are written for 1z0-082
Understanding Oracle Database Architecture11 questions
This domain explains how an Oracle database is built. Candidates describe instance configurations, the memory and process structures, the logical and physical database structures, and the server architecture that links them.
Skills tested
- Describe the memory structures and background processes that make up an instance.
- Relate logical structures, such as tablespaces and segments, to the physical files on disk.
- Explain how a client connection reaches a server process in the database server architecture.
Questions by topic
- Understanding Oracle Database Memory and Process Structures9
- Database Design and Configuration1
- Comparing Dedicated and Shared Server Configurations1
Managing Database Instances13 questions
Here candidates run the instance from day to day. They start it up and shut it down, query data dictionary and dynamic performance views, manage initialization parameter files, and read the alert log and trace files in the Automatic Diagnostic Repository (ADR).
Skills tested
- Start an instance through its stages and shut it down in the mode that a situation needs.
- Query data dictionary views and dynamic performance views to inspect the database.
- Change initialization parameters in a server parameter file or a text parameter file.
- Find errors in the alert log and in trace files.
Questions by topic
- Starting Up Oracle Database Instances6
- Managing Initialization Parameter Files4
- Using Dynamic Performance Views2
- Database Design and Configuration1
Managing Users, Roles and Privileges12 questions
This domain decides who can do what in the database. Candidates create users, grant privileges and roles, assign quotas and profiles, and choose how users are authenticated.
Skills tested
- Create users and grant them system and object privileges through roles.
- Assign tablespace quotas, and profiles that set password and resource limits.
- Apply the principle of least privilege when giving access.
- Choose a user authentication method, such as password or operating system authentication.
Questions by topic
- Applying the Principal of Least Privilege6
- Creating and Assigning Profiles4
- Managing Oracle Database Users, Privileges, and Roles2
Managing Storage13 questions
This domain is about how Oracle uses space inside segments and blocks. It covers block space management, segment types, space-saving features, table and row compression, shrinking segments, resumable space allocation and deferred segment creation.
Skills tested
- Explain how rows fill the free space in a data block.
- Shrink a segment to give back space that it no longer uses.
- Choose table or row compression to save space.
- Enable resumable space allocation so that a statement pauses instead of failing when space runs out.
Questions by topic
- Understanding Block Space Management4
- Deferring Segment Creation4
- Shrinking Segments3
- Using Table and Row Compression2
Managing Tablespaces and Datafiles12 questions
Candidates create, alter and drop tablespaces and look up their details. The domain also covers how table data is stored, Oracle Managed Files, and moving or renaming data files while the database stays online.
Skills tested
- Create, alter and drop tablespaces, and view their details in the data dictionary.
- Implement Oracle Managed Files so the database names and places its own files.
- Move or rename a data file without taking it offline.
Questions by topic
- Creating, Altering and Dropping Tablespaces6
- Implementing Oracle Managed Files2
- Database Design and Configuration1
- Viewing Tablespace Information3
Managing Undo8 questions
Undo data lets Oracle roll back a transaction and give other sessions a consistent view of the data. Candidates explain how undo is stored, configure undo retention, and compare undo data with redo data and temporary undo.
Skills tested
- Explain what undo data a transaction creates and where Oracle stores it.
- Configure undo retention so that long-running queries keep a consistent view.
- Compare undo data with redo data, and describe temporary undo.
Questions by topic
- Configuring Undo Rentention5
- Understanding Transactions and Undo Data3
Moving Data10 questions
This domain covers three ways to move data into and out of a database: SQL*Loader for flat files, Oracle Data Pump for export and import, and external tables for reading files with SQL.
Skills tested
- Load rows from a flat file into a table with SQL*Loader.
- Export and import tables or schemas with Oracle Data Pump.
- Query a file through an external table without loading it first.
Questions by topic
- Using SQL*Loader5
- Using Oracle Data Pump5
Accessing an Oracle Database with Oracle supplied Tools8 questions
Candidates pick the right Oracle tool for each task: the Database Configuration Assistant (DBCA) to create databases, Oracle Enterprise Manager to monitor them, and SQL Developer or SQL*Plus to run SQL.
Skills tested
- Create and configure a database with DBCA.
- Connect to a database and run statements in SQL*Plus and SQL Developer.
- Monitor and administer a database with Oracle Enterprise Manager.
Questions by topic
- Using the Database Configuration Assistant (DBCA)3
- Using SQL Developer2
- Using Substitution Variables1
- Using Oracle enterprise Manager Database Express2
Configuring Oracle Net Services18 questions
This domain connects clients to databases over the network. It covers the Oracle Net Services administration tools, the Oracle Net listener, naming methods, dedicated and shared server configurations, and communication between database instances.
Skills tested
- Configure the Oracle Net listener and check its status.
- Administer naming methods that turn a connect identifier into a connect descriptor.
- Compare dedicated and shared server configurations.
- Set up communication between two database instances.
Questions by topic
- Connecting to an Oracle Database Instance3
- Comparing Dedicated and Shared Server Configurations5
- Administering Naming Methods4
- Configuring Communication Between Database Instances3
- Configuring the Oracle Net Listener3
Oracle Database: Introduction to SQL120 questions
The SQL part of the exam follows Oracle's Introduction to SQL course. It runs from SELECT statements, functions, joins and subqueries to DML, DDL, schema objects and data in different time zones.
Skills tested
- Restrict and sort rows, and use substitution variables with DEFINE and VERIFY.
- Apply character, number, date and conversion functions, including NVL, NULLIF and COALESCE.
- Join tables with outer joins, self-joins and non-equijoins.
- Combine queries with UNION, UNION ALL, INTERSECT and MINUS.
- Manage transactions, constraints, views, sequences, synonyms and indexes.
Questions by topic
- Managing Schema Objects12
- Displaying Data from Multiple Tables Using Joins12
- Using Conversion Functions and Conditional Expressions8
- Using SET Operators9
- Managing Data in Different Time Zones7
- Reporting Aggregated Data Using Group Functions7
- Understanding Data Definition Language8
- Using Subqueries to Solve Queries8
- Managing Sequences, Synonyms, Indexes9
- Restricting and Sorting Data11
- Managing Views9
- Managing Tables using DML statements12
- Using Single-Row Functions to Customize Output8
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: hands-on experience with Oracle Database and with SQL fundamentals.
- Recommended: knowledge of database administration concepts and some PL/SQL programming.
About the 1z0-082 exam
Oracle Database Administration I (1z0-082) tests the core skills of an administrator who runs Oracle Database 19c. Its topics come from two Oracle courses. The Administration Workshop supplies architecture, instances, users, storage, undo, data movement and Oracle Net Services, and Introduction to SQL supplies queries and schema objects. Passing this exam and Oracle Database Administration II earns the Oracle Database Administration 2019 Certified Professional credential.
SQL topics hold a large share of the PlanetCert practice test, from outer joins and subqueries to set operators and DML. Among the administration domains, Configuring Oracle Net Services has the most questions, with dedicated and shared server configurations and naming methods. The explanations help where two answers look close, such as undo and redo data, or a role and a profile. Flashcard Mode suits the many tool and view names. Brainy AI Assistant can explain why a query returns more rows than expected, or what undo retention protects.
How to earn the certification
- Earns
- Oracle Database Administration 2019 Certified ProfessionalProfessional
Oracle Database Administration 2019 Certified Professional does not expire.
- After
- 1z0-083 Oracle Database Administration II
The second required exam. Passing both exams earns the Oracle Database Administration 2019 Certified Professional credential.
- 1Z0-084 Oracle Database 19c: Performance Management and Tuning
A later 19c exam on finding and fixing database performance problems.
- 1z0-083 Oracle Database Administration II
How to prepare for 1z0-082
- 1
Install a 19c lab database
Install Oracle Database 19c in a virtual machine and create a database with DBCA. A working lab lets every administration topic be tried by hand.
- 2
Write SQL every day
The SQL course supplies many of the exam topics. Write queries daily in SQL*Plus or SQL Developer, from joins and subqueries to set operators and conversion functions.
- 3
Fill a tablespace on purpose
Fill a small tablespace until a statement fails, then add a datafile or enable resumable space allocation. Shrink a segment afterward and check the space it frees.
- 4
Trace a client connection
Configure the listener and a naming method, connect from a client, then switch between dedicated and shared server. Check the listener status after each change.
- 5
End with a timed full run
Take the 1z0-082 practice test in Timed Mode once each domain feels familiar. Ask Brainy AI Assistant to explain any wrong SQL answer clause by clause.
Start a timed 1z0-082run
Oracle's own courses for this exam are Oracle Database: Administration Workshop and Oracle Database: Introduction to SQL. Oracle MyLearn also has a learning path for the full Oracle Database Administration 2019 Certified Professional credential.
Who 1z0-082 is for
- Junior Oracle database administrators who look after 19c databases.
- Database developers and consultants who need administration skills alongside SQL.
- System administrators who support the servers that run Oracle Database.
- Technical support staff who solve Oracle Database problems for customers.
Typical job titles: Database administrator · Database developer · Database consultant · Systems administrator · Technical support engineer
1z0-082 glossary
18 terms from the exam objectives and the vendor's official material, each defined in a sentence.
- Alert log
- A log of major database events, such as startups, shutdowns and errors, kept in the ADR.
- Automatic Diagnostic Repository (ADR)
- The file-based store where the database keeps its alert log, trace files and other diagnostic data.
- Data dictionary views
- Read-only views that describe the objects, users and storage of the database.
- Database Configuration Assistant (DBCA)
- Oracle's guided tool for creating, configuring and deleting databases.
- Dynamic performance views
- Views whose names start with V$ and that show the current state and activity of the instance.
- External tables
- Read-only tables whose data stays in files outside the database but can be queried with SQL.
- Naming methods
- The ways Oracle Net turns a connect identifier into a connect descriptor, such as local naming or Easy Connect.
- Oracle Data Pump
- Oracle's tools for fast export and import of data and metadata between databases.
- Oracle Managed Files
- A feature in which the database creates, names and deletes its own datafiles in a set location.
- Oracle Net listener
- The process on the database server that receives client connection requests and passes them to the database.
- Redo data
- Records of every change made to the database, used to recover the database after a failure.
- Resumable space allocation
- A feature that pauses a statement that runs out of space, so that an administrator can add space before it fails.
- Shared server
- A configuration in which many client sessions share a small pool of server processes, instead of one process each.
- SQL*Loader
- An Oracle tool that loads data from external flat files into database tables.
- Substitution variables
- Placeholders, marked with an ampersand, that SQL*Plus replaces with a value before it runs a statement.
- Tablespace
- A logical unit of storage that groups segments, such as tables and indexes, and maps to one or more datafiles.
- Undo data
- Copies of data as it was before a change, used to roll back transactions and to give consistent reads.
- Undo retention
- The time for which Oracle tries to keep committed undo data, so that long queries can still read it.