O R A C L E C E R T I F I C A T I O N
1Z0-083 Oracle Database Administration II Practice Exam
Exam Number: 4803 | Last updated April 19, 2026 | 875+ questions across 5 vendor-aligned objectives
The 1Z0-083 Oracle Database Administration II exam is the second half of the Oracle Certified Professional DBA journey. It is written for experienced administrators who already operate Oracle Database and are ready to validate deeper skills in RMAN-driven backup and recovery, multitenant administration, performance tuning, upgrade and patching, and Data Guard basics. Earning it confirms the candidate can protect, move, and evolve production Oracle Database environments at scale.
The heaviest objective is Backup, Recovery, and Data Movement (roughly 35%), covering complete and point-in-time RMAN restores, cross-platform transport, Data Pump strategies, and block media recovery. Managing Multitenant Databases and Application Containers contributes another 25% with PDB cloning, hot clone, refresh, and application PDB lifecycle.
Upgrading and Patching Oracle Database Software sits near 20% and drills into AutoUpgrade, DBUA, rolling patches, and rollback procedures. The remaining weight covers Managing Performance with AWR, ADDM, and SQL Tuning Advisor, plus Configuring Oracle Data Guard for standby databases.
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 →
872
practice exam users
98.1%
satisfied users
96.7%
passed the exam
4.7/5
quality rating
Test your 1Z0 083 Database Admin II knowledge
10 of 875+ questions
Question #1 - Backup, Recovery, and Data Movement
A senior DBA at a financial services firm has just discovered that a single datafile in the USERS tablespace is corrupt. The database is open and active, and she wants to restore only the damaged blocks without taking the whole tablespace offline.
Which RMAN feature addresses this scenario?
A) Block Media Recovery using RECOVER DATAFILE … BLOCK.
B) Flashback Database to before the corruption.
C) A full RMAN RESTORE DATABASE.
D) Drop and re-create the tablespace.
Show solution
Correct answers: A – Explanation:
Block Media Recovery lets RMAN restore and recover specific blocks while the rest of the datafile (and the database) remains online, minimizing outage. Option C is overkill and requires a full restore. Option B rewinds the entire database, discarding good work done since the corruption. Option D destroys data instead of repairing it. Source: Check Source
Question #2 - Managing Multitenant Databases and Application Containers
A DBA at a SaaS provider is cloning a PDB from a production container database to a test CDB in the same cluster. She wants the clone to refresh automatically every 24 hours from the source.
Which PDB operation supports this automatic refresh?
A) ALTER PLUGGABLE DATABASE … UNPLUG INTO
B) CREATE PLUGGABLE DATABASE … FROM … REFRESH MODE EVERY 1440 MINUTES
C) CREATE PLUGGABLE DATABASE … NOCOPY
D) CREATE PLUGGABLE DATABASE … SNAPSHOT COPY
Show solution
Correct answers: B – Explanation:
A refreshable PDB uses REFRESH MODE EVERY n MINUTES to periodically apply incremental changes from the source. Option C creates a plug-in that reuses existing files, with no refresh behavior. Option A unplugs a PDB rather than cloning it. Option D creates a point-in-time snapshot, not an ongoing refresh. Source: Check Source
Question #3 - Upgrading and Patching Oracle Database Software
A DBA is preparing to upgrade an Oracle 12.2 database to 19c using AutoUpgrade. She wants to run only the preliminary checks so she can see any blockers before scheduling the actual upgrade window.
Which AutoUpgrade mode performs checks without modifying the database?
A) -mode deploy
B) -mode upgrade
C) -mode analyze
D) -mode restore
Show solution
Correct answers: C – Explanation:
AutoUpgrade’s analyze mode runs prechecks and reports blockers or warnings without touching the database — ideal for pre-upgrade planning. Deploy mode runs the full sequence including fixups and upgrade. Upgrade mode skips prechecks already performed but still modifies the database. Restore mode restores from the guaranteed restore point. Source: Check Source
Question #4 - Performance and Data Guard
A performance engineer at a stock exchange wants an automatic diagnostic report covering the last hour of database activity, including top SQL, wait events, and instance-level bottlenecks. He prefers an Oracle-supplied report rather than writing custom queries.
Which report satisfies this?
A) DBA_HIST_SNAPSHOT listing.
B) V$SESSION snapshot.
C) ALERT log review.
D) Automatic Workload Repository (AWR) report.
Show solution
Correct answers: D – Explanation:
An AWR report compares two snapshots and presents a comprehensive view of workload, top SQL, wait events, and instance statistics — exactly the requirement. Option B is a point-in-time dump of sessions. Option C captures errors and diagnostic messages but not performance metrics. Option A lists snapshots but does not produce a report on its own. Source: Check Source
Question #5 - Backup, Recovery, and Data Movement
A DBA at a logistics company needs to transport a tablespace containing read-only reference data from an Oracle 19c database on Linux x86-64 to another 19c database on the same platform. She wants the fastest supported procedure.
Which approach is recommended?
A) Transportable Tablespace using Data Pump to export metadata and copy the datafiles.
B) Full database export/import with expdp and impdp.
C) A series of CREATE TABLE AS SELECT statements over a database link.
D) RMAN DUPLICATE DATABASE.
Show solution
Correct answers: A – Explanation:
Transportable Tablespaces copy datafiles physically and use Data Pump to move only metadata, which is dramatically faster than logical export/import for large data. Option B is a logical copy of everything — slower and unnecessary. Option C performs row-by-row moves. Option D duplicates the whole database. Source: Check Source
Question #6 - Managing Multitenant Databases and Application Containers
A DBA is consolidating three non-CDB databases into a single 19c multitenant container. The first non-CDB is 12.2 and the DBA wants to plug it into the new CDB without performing a full Data Pump export/import.
Which path is supported?
A) Copy the datafiles and run CREATE PLUGGABLE DATABASE without any metadata step.
B) Use DBMS_PDB to describe the non-CDB, create an XML manifest, and plug it in as a PDB.
C) Run ALTER DATABASE CONVERT TO CDB on the non-CDB in place.
D) Use SQL*Loader to stream data into the target CDB.
Show solution
Correct answers: B – Explanation:
The supported non-CDB-to-PDB conversion path uses DBMS_PDB.DESCRIBE to generate an XML manifest of the non-CDB, then CREATE PLUGGABLE DATABASE USING the manifest to plug it into the target CDB, followed by running noncdb_to_pdb.sql. Option A skips the metadata step and will not work. Option C is not a valid command. Option D is a data loader, not a conversion tool. Source: Check Source
Question #7 - Upgrading and Patching Oracle Database Software
A DBA at a media streaming company is applying a quarterly Release Update (RU) using OPatch in a Grid Infrastructure environment. Before applying, she wants a safety net so she can roll back the entire patched database quickly if the RU causes issues.
Which feature is best to set up before the patch?
A) An RMAN incremental backup.
B) A Data Guard far sync instance.
C) A guaranteed restore point.
D) A full Data Pump export.
Show solution
Correct answers: C – Explanation:
A guaranteed restore point, together with flashback logging, gives the DBA a fast rewind mechanism — FLASHBACK DATABASE TO RESTORE POINT — to revert the entire database if the RU fails. Option A still requires a longer restore-and-recover sequence. Option D captures logical data but does not rewind state. Option B improves redo transport, not rollback of a patch. Source: Check Source
Question #8 - Backup, Recovery, and Data Movement
A DBA at a pharmaceutical firm needs to restore a lost CONTROL file. The database is down, the backup is in the Fast Recovery Area, and autobackup of control files is enabled.
Which RMAN command sequence restores and mounts the control file?
A) ALTER DATABASE OPEN RESETLOGS;
B) STARTUP MOUNT; RESTORE DATABASE;
C) SHUTDOWN ABORT; RECOVER CONTROLFILE;
D) STARTUP NOMOUNT; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT;
Show solution
Correct answers: D – Explanation:
With no control file available, the instance can only start to NOMOUNT. RESTORE CONTROLFILE FROM AUTOBACKUP locates the most recent autobackup, and MOUNT attaches the new control file so recovery can proceed. Option B fails because MOUNT requires a control file. Option C is not a valid RMAN command. Option A is issued only after full recovery completes. Source: Check Source
Question #9 - Performance and Data Guard
A DBA at an online retailer is configuring a physical standby database for disaster recovery. She needs synchronous redo transport to the standby to guarantee zero data loss and wants the primary to wait for standby acknowledgment before a commit returns to the application.
Which Data Guard protection mode meets this requirement?
A) Maximum Protection
B) Maximum Availability
C) Read-Only Standby
D) Maximum Performance
Show solution
Correct answers: A – Explanation:
Maximum Protection uses SYNC AFFIRM transport and shuts down the primary if the standby cannot acknowledge, guaranteeing zero data loss. Maximum Availability is SYNC but falls back to async if the standby is unreachable, so zero data loss is not absolute. Maximum Performance is async. Read-Only Standby is an open-state, not a protection mode. Source: Check Source
Question #10 - Managing Multitenant Databases and Application Containers
A DBA at a SaaS company has an application container with a shared catalog across 120 tenant PDBs. She needs to roll out a new version of the common sales_app application from 1.0 to 2.0 and propagate the upgrade to every application PDB.
Which sequence is correct for application container upgrades?
A) ALTER SYSTEM UPGRADE APPLICATION ‘sales_app’ GLOBAL=TRUE in every PDB individually.
B) DROP APPLICATION sales_app; CREATE APPLICATION sales_app NEW VERSION ‘2.0’; restart container.
C) ALTER PLUGGABLE DATABASE APPLICATION sales_app BEGIN UPGRADE ‘1.0’ TO ‘2.0’; run upgrade scripts; ALTER … END UPGRADE; then run ALTER PLUGGABLE DATABASE APPLICATION sales_app SYNC in each application PDB.
D) Plug a new application root into each PDB with USING ‘/tmp/2.0.xml’.
Show solution
Correct answers: C – Explanation:
Application containers track named applications with versions. BEGIN UPGRADE / END UPGRADE at the application root brackets the upgrade, and SYNC in each application PDB pulls the new version. Option B destroys and rebuilds, losing tenant data. Option D confuses PDB plug-in with application version management. Option A is not a valid command path. 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 083 Database Admin II exam measures
- Backup, recovery, and data movement (35%) — run RMAN full, incremental, duplicate, and point-in-time operations, perform block media recovery, and move data across platforms with transportable tablespaces and Data Pump.
- Managing multitenant databases and application containers (25%) — clone, hot clone, refresh, relocate, and unplug and plug pluggable databases, and administer application containers with root replicas.
- Upgrading and patching (20%) — plan and execute AutoUpgrade and DBUA upgrades, apply release updates and patches, and use guaranteed restore points for safe rollback.
- Performance and Data Guard (20%) — diagnose with AWR and ADDM, tune SQL with the SQL Tuning Advisor, and configure physical standby databases for high availability.
How to prepare for this exam
- Review the official 1Z0-083 exam page so you understand every objective, skill group, and weight before opening a practice session.
- Complete the Oracle University Oracle Database: Deploy, Patch, and Upgrade Workshop learning path on MyLearn.
- Build a two-node lab in an OCI always-free tenancy, practice full RMAN duplicate-to-standby flows, and rehearse an AutoUpgrade end to end.
- Apply the skills at work: own a production upgrade, patch a staging PDB, or refactor a weekly backup plan to use RMAN compressed backupsets.
- Master one objective at a time, starting with backup, recovery, and data movement 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 objectives until you pass three full-length attempts in a row.
Career paths and salary outlook
1Z0-083 anchors senior DBA roles and related data-platform tracks:
- Senior Oracle Database Administrator — $115,000–$160,000 (Glassdoor).
- Database Reliability Engineer — $130,000–$180,000 (Levels.fyi).
- Data Platform Architect — $145,000–$200,000 (PayScale).
Official resources
Work through the Oracle Database Administrator Learning Path on Oracle MyLearn, then supplement with the Oracle Database Backup and Recovery User’s Guide, the Database Upgrade Guide, and the Data Guard Concepts and Administration handbook.