O R A C L E C E R T I F I C A T I O N
1Z0-082 Oracle Database Administration I Practice Exam
Exam Number: 4802 | Last updated April 19, 2026 | 875+ questions across 5 vendor-aligned objectives
The 1Z0-082 Oracle Database Administration I certification is aimed at aspiring and junior database administrators who install, configure, and operate Oracle Database day to day. Candidates demonstrate command of the multitenant architecture, instance startup and shutdown, storage and undo management, user and privilege administration, backup basics, and the SQL foundations every DBA writes daily. Passing is a required step toward the Oracle Certified Professional DBA credential.
The largest content area is Managing Database Instances, Storage, and Security (approximately 35%), covering parameter files, memory and process architecture, tablespaces, undo management, users, profiles, and privileges. Understanding Oracle Database Architecture accounts for around 25% and includes the multitenant container database, pluggable databases, the data dictionary, and ASM basics.
Managing Data and Concurrency sits at roughly 20% with a focus on transactions, locks, and read consistency. Backup, Recovery, and Moving Data covers another 20%, introducing RMAN, flashback, Data Pump, and SQL*Loader — the core toolkit every new DBA ships against on week one.
Every answer links to the source. Each explanation below includes a hyperlink to the exact Oracle documentation page the question was derived from. PowerKram is the only practice platform with source-verified explanations. Learn about our methodology →
634
practice exam users
97.9%
satisfied users
96.4%
passed the exam
4.2/5
quality rating
Test your 1Z0 082 Database Admin I knowledge
10 of 875+ questions
Question #1 - Understanding Oracle Database Architecture
A new DBA at a utility company has inherited an Oracle 19c multitenant environment. She needs to execute a query that returns all PDBs, including their open mode and status, and must run the query from the root container.
Which data dictionary view should she query from the root container?
A) V$PDBS
B) DBA_TABLES
C) V$DATABASE
D) USER_OBJECTS
Show solution
Correct answers: A – Explanation:
V$PDBS is the dynamic performance view that lists each pluggable database along with its open_mode and status. It is accessible from the root container (CDB$ROOT) and returns every PDB registered with the instance. Option C returns one row describing the container database as a whole, not each PDB. Option B lists table metadata across the current container. Option D lists objects owned by the current user, not PDBs. Source: Check Source
Question #2 - Managing Database Instances, Storage, and Security
A logistics provider’s lead DBA is building a new tablespace for a data mart. The tablespace must automatically grow when it fills up, with each extent being 8 MB, up to a maximum of 32 GB.
Which CREATE TABLESPACE statement matches the requirements?
A) ALTER TABLESPACE dm_ts ADD DATAFILE AUTOGROW 8M;
B) CREATE TABLESPACE dm_ts DATAFILE ‘/u01/dm.dbf’ SIZE 100M AUTOEXTEND ON NEXT 8M MAXSIZE 32G;
C) CREATE TABLESPACE dm_ts DATAFILE ‘/u01/dm.dbf’ SIZE 100M AUTOEXTEND OFF;
D) CREATE TABLESPACE dm_ts DATAFILE ‘/u01/dm.dbf’ SIZE 32G AUTOEXTEND ON MAXSIZE UNLIMITED;
Show solution
Correct answers: B – Explanation:
AUTOEXTEND ON with NEXT 8M tells Oracle to grow the datafile in 8 MB increments, and MAXSIZE 32G caps the total at 32 GB — precisely what the requirement specified. Option C turns autoextend off entirely. Option D preallocates 32 GB up front and sets an unlimited cap, which is wasteful and contradicts the 32 GB max. Option A uses AUTOGROW, which is not valid Oracle syntax. Source: Check Source
Question #3 - Understanding Oracle Database Architecture
A junior DBA at a news portal is investigating why a common user created at the root level does not automatically have access inside a newly plugged-in PDB. The user was created with CONTAINER=ALL, but queries inside the new PDB return ORA-01031 insufficient privileges.
What is the most likely cause?
A) Common users require a local synonym in each PDB to work.
B) Common users are never visible inside PDBs.
C) The privileges granted to the common user were granted with CONTAINER=CURRENT, not CONTAINER=ALL.
D) The PDB must be restarted before common users become active.
Show solution
Correct answers: C – Explanation:
A common user created at the root with CONTAINER=ALL exists in every PDB, but privileges granted separately with CONTAINER=CURRENT only apply in the container where they were granted. To give the common user privileges across all containers, the grant itself must use CONTAINER=ALL. Option B is wrong because common users do exist in PDBs. Option D is wrong because a PDB restart is not required. Option A is wrong because synonyms are not a privilege-grant mechanism. Source: Check Source
Question #4 - Managing Data and Concurrency
Two sessions at an e-commerce company are updating the same PRODUCTS row. Session A issues UPDATE on product_id = 500 and does not commit. Session B then issues UPDATE on the same row.
What happens to session B?
A) Session B silently succeeds, and session A’s change is discarded on commit.
B) Session B receives an ORA-00060 deadlock error.
C) Session B immediately overwrites session A’s changes because Oracle uses last-writer-wins.
D) Session B blocks waiting until session A commits or rolls back.
Show solution
Correct answers: D – Explanation:
Oracle uses row-level locks. When session A updates a row without committing, it holds an exclusive lock. Session B’s UPDATE on the same row will block and wait until session A either commits or rolls back. Option C describes a lost-update pattern Oracle does not allow on uncommitted data. Option B requires a circular wait across multiple rows to trigger a deadlock. Option A is not how row locking works — writes are serialized, not silently overridden. Source: Check Source
Question #5 - Backup, Recovery, and Moving Data
A DBA at a biotech firm wants to run a compressed full backup of the entire database using RMAN. The backup should include archived redo logs and use the default backupset compression.
Which RMAN command accomplishes this?
A) BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
B) EXPORT FULL=Y COMPRESS=Y;
C) BACKUP DATABASE PLUS ARCHIVELOG;
D) BACKUP AS COPY DATABASE;
Show solution
Correct answers: A – Explanation:
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG instructs RMAN to produce compressed backup sets for all datafiles and include archived redo logs in the same run. Option C performs a full database archivelog backup but does not compress. Option D uses image copies, which cannot be compressed by RMAN. Option B is a Data Pump export syntax pattern, not an RMAN backup command. Source: Check Source
Question #6 - Managing Database Instances, Storage, and Security
A security-conscious DBA at a government agency wants to enforce that user passwords must be at least 12 characters and must be changed every 60 days. She plans to apply these rules to all new users by default.
Which Oracle feature enforces these two password rules together?
A) A system trigger on LOGON that checks password age.
B) A profile with password verification function and PASSWORD_LIFE_TIME set to 60.
C) A tablespace quota per user.
D) A role granted to each user at creation time.
Show solution
Correct answers: B – Explanation:
User profiles let you group and enforce resource and password rules; a profile with PASSWORD_LIFE_TIME=60 plus a password verification function that enforces minimum length is the standard mechanism. Option D grants privileges but does not control password complexity or age. Option A could detect stale passwords after login but would not enforce complexity on password change. Option C manages storage, not authentication. Source: Check Source
Question #7 - Understanding Oracle Database Architecture
A DBA at a research lab is diagnosing memory pressure in an Oracle 19c instance. She recalls that the SGA contains several pools and wants a quick summary of the buffer cache, shared pool, large pool, java pool, and streams pool to check for resizing.
Which dynamic view summarizes the current memory allocation across SGA components?
A) V$DATAFILE
B) DBA_SEGMENTS
C) V$SGAINFO
D) V$INSTANCE
Show solution
Correct answers: C – Explanation:
V$SGAINFO lists each SGA component (buffer cache, shared pool, large pool, java pool, streams pool, fixed SGA, etc.) with its current size, which is ideal for a quick summary. Option A reports datafiles, not memory. Option D describes the instance state at a high level without per-pool sizing. Option B lists segment storage in tablespaces. Source: Check Source
Question #8 - Managing Data and Concurrency
A retail analyst accidentally deleted 800 rows from a promotional pricing table 15 minutes ago. The transaction was committed. The DBA wants to retrieve the lost rows without restoring from a full backup, and undo retention is set to 1 hour.
Which technique is best suited to recover the deleted rows quickly?
A) RMAN RESTORE DATABASE UNTIL TIME.
B) Full Data Pump import from last night’s export.
C) A log miner session against all redo logs since startup.
D) Flashback Query using AS OF TIMESTAMP.
Show solution
Correct answers: D – Explanation:
Flashback Query (SELECT … AS OF TIMESTAMP) uses undo to return the rows as they existed at a past time within the undo retention window, so a 15-minute-old delete is recoverable with a simple INSERT … SELECT AS OF. Option A is a heavy point-in-time restore that takes the database offline. Option B loses any activity after last night’s export. Option C is workable but far more complex than a flashback query. Source: Check Source
Question #9 - Backup, Recovery, and Moving Data
A pharmaceutical firm’s DBA needs to move a large, self-contained schema from one Oracle 19c database to another. Network bandwidth is limited, so she wants the fastest export-and-import path that preserves dependencies like indexes and constraints.
Which tool fits best?
A) Data Pump (expdp/impdp) with a SCHEMAS parameter.
B) Manual DDL extraction followed by row-by-row INSERT via SQL*Loader.
C) SQL*Plus with SPOOL to a CSV file.
D) A series of CREATE TABLE AS SELECT statements over a database link.
Show solution
Correct answers: A – Explanation:
Data Pump with SCHEMAS=
Question #10 - Managing Database Instances, Storage, and Security
A DBA at a telecom operator needs to grant a developer the ability to SELECT from three specific tables in the HR schema. The developer should not be able to see any other tables.
Which approach follows least-privilege best practice?
A) CREATE ROLE full_hr; GRANT SELECT ON hr.* TO full_hr; GRANT full_hr TO developer_user;
B) GRANT SELECT ANY TABLE TO developer_user;
C) GRANT SELECT ON hr.employees, hr.departments, hr.jobs TO developer_user;
D) GRANT DBA TO developer_user;
Show solution
Correct answers: C – Explanation:
Object privileges granted per-table (or via a custom role limited to those three tables) honor least-privilege: the developer gets exactly what the requirement states, no more. Option D hands over full administrator access. Option B gives read access to every table in the database. Option A over-grants — hr.* includes tables beyond the three required. Source: Check Source
Get 875+ more questions with source-linked explanations
Every answer traces to the exact Oracle documentation page — so you learn from the source, not just memorize answers.
Exam mode & learn mode · Score by objective · Updated April 19, 2026
Learn more...
What the 1Z0 082 Database Admin I exam measures
- Managing database instances, storage, and security (35%) — start and stop instances, manage parameter files, create and size tablespaces, configure undo retention, and administer users, profiles, and system and object privileges under least-privilege principles.
- Understanding Oracle Database architecture (25%) — navigate the multitenant container and pluggable database model, the memory and process architecture, the data dictionary, and Automatic Storage Management fundamentals.
- Managing data and concurrency (20%) — control transactions, interpret lock behavior, enforce read consistency, and use flashback query to investigate point-in-time data.
- Backup, recovery, and moving data (20%) — execute full and incremental RMAN backups, perform complete and point-in-time restores, and move data with Data Pump and SQL*Loader.
How to prepare for this exam
- Review the official 1Z0-082 exam page and capture every objective, skill, and weight before you start.
- Complete the Oracle University Oracle Database Administration Workshop learning path on MyLearn, working every lab end to end.
- Stand up a practice CDB with two PDBs in an OCI always-free Autonomous Database or a local 21c install — rehearse shutdown immediate, startup mount, and plug and unplug flows until they are muscle memory.
- Apply the skills to production-grade work: volunteer to own a staging database, refactor a legacy backup script into RMAN, or rebuild tablespaces during a maintenance window.
- Master one objective at a time, beginning with instance, storage, and security since it carries the most weight.
- Run PowerKram learn mode to see feedback after every question with sourced links back to Oracle documentation.
- Finish with PowerKram exam mode across all four objectives until you clear the threshold three times in a row.
Career paths and salary outlook
1Z0-082 opens the door to the Oracle Certified Professional track and these hands-on DBA roles:
- Junior Oracle Database Administrator — $78,000–$115,000 (PayScale).
- Database Operations Engineer — $90,000–$130,000 (Glassdoor).
- Site Reliability Engineer (data platform) — $115,000–$165,000 (Levels.fyi).
Official resources
Anchor your study in the Oracle Database Administrator Learning Path on Oracle MyLearn. Reinforce with the Oracle Database Administrator’s Guide, the Oracle Multitenant Administrator’s Guide, and the Backup and Recovery User’s Guide.