PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free Oracle Database Administration II Practice Questions

Prepare for the Oracle Database Administration II (1Z0-083) exam with instant access — no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Oracle SQL

Practice QuestionsStudy Guide1 video1 blog

Oracle Java SE 21 Developer

Practice QuestionsStudy Guide

Oracle DBA

Practice Questions

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

More From This Family

Videos and articles for deeper review.

VideoOracle SQL 1Z0-071 Exam Guide 2026: Active Status, Format, and Study PlanArticleOracle SQL 1Z0-071 Exam Guide 2026: Active Status, Format, and Study Plan15 min read
2026 Statistics

Key Facts: Oracle Database Administration II Exam

$245

Exam Fee (USD)

Oracle

~80

Question Count (typical)

Oracle | Pearson VUE

150 min

Exam Duration

Oracle

~60%

Passing Score (approximate)

Oracle (exact percentage not published)

No expiry

OCP Credential Validity

Oracle

19c and 21c

Versions Covered

Oracle (version-agnostic exam)

Oracle lists exam 1Z0-083, Oracle Database Administration II, as the second OCP exam, delivered through Pearson VUE for about $245 USD. It typically presents around 80 multiple-choice and multiple-select questions in 150 minutes, with a passing score near 60 percent, and the OCP credential does not expire. The version-agnostic blueprint covers multitenant CDB and PDB management, RMAN backup and recovery, Flashback technologies, performance tuning with AWR and ADDM, AutoUpgrade and patching, plus auditing, diagnostics, transporting data, and database duplication.

Sample Oracle Database Administration II Practice Questions

Try these sample questions to test your Oracle Database Administration II exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1You want to create a new pluggable database named SALESPDB inside an existing multitenant container database by copying the PDB$SEED. Which statement creates it correctly?
A.CREATE PLUGGABLE DATABASE salespdb ADMIN USER pdbadmin IDENTIFIED BY pwd;
B.CREATE DATABASE salespdb USING SEED;
C.ALTER CONTAINER DATABASE ADD PLUGGABLE salespdb;
D.CREATE PDB salespdb FROM PDB$SEED OPEN;
Explanation: CREATE PLUGGABLE DATABASE ... ADMIN USER ... IDENTIFIED BY clones PDB$SEED to build a brand new PDB. The ADMIN USER clause is mandatory when creating from the seed because Oracle creates a local administrator with the PDB_DBA role inside the new PDB.
2A newly created PDB shows OPEN_MODE of MOUNTED in V$PDBS after the CDB instance restarts. Which action ensures the PDB opens automatically the next time the CDB starts?
A.Set the CDB initialization parameter OPEN_PDBS=ALL.
B.ALTER PLUGGABLE DATABASE salespdb SAVE STATE; while it is open.
C.ALTER PLUGGABLE DATABASE salespdb OPEN PERSISTENT;
D.Add the PDB to the spfile with ALTER SYSTEM SET PDB_OPEN=ON;
Explanation: Saving the open state with ALTER PLUGGABLE DATABASE ... SAVE STATE records the PDB's current open mode in the data dictionary so it is automatically reopened when the CDB restarts. Without a saved state, PDBs start in MOUNTED mode.
3Before you can plug an unplugged PDB into a target CDB, you should verify compatibility. Which procedure or function reports whether the PDB is compatible with the target CDB?
A.DBMS_PDB.DESCRIBE
B.DBMS_PDB.RECOVER
C.DBMS_PDB.CHECK_PLUG_COMPATIBILITY
D.DBMS_PDB.EXPORTRMANBACKUP
Explanation: DBMS_PDB.CHECK_PLUG_COMPATIBILITY returns TRUE if the PDB described in an XML metadata file is compatible with the target CDB. You run it before issuing CREATE PLUGGABLE DATABASE ... USING the XML file. Incompatibilities are written to PDB_PLUG_IN_VIOLATIONS.
4You unplug a PDB with ALTER PLUGGABLE DATABASE hrpdb UNPLUG INTO '/tmp/hrpdb.xml'. Immediately afterward, what is the state of HRPDB in the source CDB?
A.It is dropped from the CDB and its datafiles are deleted.
B.It is automatically converted into a non-CDB.
C.It continues to open READ WRITE for application access.
D.It remains in the CDB in MOUNTED state and cannot be opened until it is dropped or replugged.
Explanation: After UNPLUG INTO, the PDB stays in the CDB's data dictionary in MOUNTED (unplugged) state and cannot be opened. You typically follow with DROP PLUGGABLE DATABASE ... KEEP DATAFILES so the datafiles can be plugged into another CDB using the generated XML.
5You must clone an open PDB named PRODPDB into the same CDB as a hot clone for testing. What must be true about PRODPDB for a hot clone to succeed?
A.The source CDB must be in ARCHIVELOG mode and local undo must be enabled.
B.PRODPDB must be in READ ONLY mode.
C.PRODPDB must first be unplugged.
D.The CDB must be shut down to NOMOUNT.
Explanation: Hot cloning an open (READ WRITE) PDB requires the CDB to run in ARCHIVELOG mode and use local undo, because Oracle uses redo to make the clone transactionally consistent. With local undo and ARCHIVELOG, you can clone a PDB while it stays open for transactions.
6Which clause of CREATE PLUGGABLE DATABASE lets you relocate a PDB from a remote CDB to the local CDB in a single command using a database link, leaving the source unavailable at the end?
A.USING XML FILE
B.FROM remote_pdb@dblink RELOCATE
C.AS CLONE
D.NO DATA
Explanation: CREATE PLUGGABLE DATABASE ... FROM source_pdb@dblink RELOCATE performs an online relocation: the PDB is moved to the target CDB and, when you open it, the source PDB is closed and dropped. The AVAILABILITY MAX option further minimizes downtime.
7You are connected to the root container. Which command switches your session's current container to the PDB named FINPDB?
A.CONNECT finpdb;
B.ALTER PLUGGABLE DATABASE finpdb SET CURRENT;
C.ALTER SESSION SET CONTAINER = finpdb;
D.USE PLUGGABLE DATABASE finpdb;
Explanation: ALTER SESSION SET CONTAINER = finpdb switches the current container of an existing session to FINPDB without a new connection, provided the user has the SET CONTAINER privilege. This is the standard way to move between the root (CDB$ROOT) and PDBs.
8A CDB uses local undo mode. Where is the undo tablespace for transactions inside a PDB located?
A.In the root container only, shared by all PDBs.
B.In the PDB$SEED, which all PDBs reference.
C.In the SYSTEM tablespace of the PDB.
D.In each PDB, which has its own undo tablespace.
Explanation: With local undo mode (the default and required for hot clones, PDB-level flashback, and relocation), every PDB maintains its own undo tablespace. This isolates undo per PDB and is needed for many multitenant operations. Shared undo keeps a single undo tablespace in the root.
9You want to limit FINPDB so that its sessions can use at most 40% of the CDB's CPU and memory through Resource Manager. Which mechanism enforces inter-PDB resource limits?
A.A CDB resource plan with directives that set shares and utilization limits per PDB.
B.A PDB lockdown profile applied to FINPDB.
C.The PDB-level parameter MAX_CPU_PERCENT.
D.A consumer group mapping inside FINPDB.
Explanation: Inter-PDB resource allocation is controlled by a CDB resource plan created with DBMS_RESOURCE_MANAGER, using directives that assign shares and utilization_limit values per PDB. You then set RESOURCE_MANAGER_PLAN to activate it in the root.
10Which data dictionary view would you query from the root to see the open mode and restricted status of every PDB in the CDB?
A.DBA_PDBS
B.V$PDBS
C.CDB_TABLESPACES
D.V$CONTAINERS only when in a PDB
Explanation: V$PDBS shows runtime information for each PDB including OPEN_MODE, RESTRICTED, and the PDB GUID. DBA_PDBS lists static metadata such as status and creation SCN but not the live OPEN_MODE. From the root, V$PDBS is the quickest live status check.

About the Oracle Database Administration II Exam

Oracle Database Administration II (exam 1Z0-083) is the second exam in the two-exam path to the Oracle Database Administration Certified Professional (OCP) credential. The exam is version-agnostic, validating administration skills across Oracle Database 19c and 21c. Its objectives center on the multitenant architecture, including creating, cloning, relocating, and securing CDBs and PDBs; backup and recovery with Recovery Manager (RMAN), including point-in-time and block-level recovery; Flashback technologies; performance diagnosis with AWR, ADDM, and SQL tuning tools; and upgrading and patching with AutoUpgrade, OPatch, and datapatch. The exam also covers Unified Auditing, privilege analysis, ADR diagnostics, transporting data, and duplicating databases.

Assessment

Question count not published by the exam provider

Time Limit

150 minutes

Passing Score

Approximately 60% (Oracle does not publish the exact percentage)

Exam Fee

$245 (Oracle (delivered through Pearson VUE))

Oracle Database Administration II Exam Content Outline

~22%

Multitenant architecture (CDB and PDB management)

Create and configure container and pluggable databases; clone hot and cold; plug, unplug, and relocate PDBs; convert non-CDBs; and manage local undo, CDB resource plans, lockdown profiles, common users, and the PDB lifecycle.

~24%

Backup and recovery with RMAN

Configure retention policies, channels, parallelism, control file autobackup, and block change tracking; take full, incremental, image-copy, and PDB backups; and perform datafile, control file, database, and PDB point-in-time recovery.

~10%

Flashback technologies

Apply Flashback Database, Flashback Table, Flashback Drop with the recycle bin, Flashback Query, Flashback Transaction Query, Flashback Data Archive, guaranteed restore points, and PDB-level flashback.

~15%

Performance management and tuning

Interpret AWR reports, ADDM findings, and ASH; use the SQL Tuning and SQL Access Advisors, SQL profiles, and SQL Plan Management baselines; and manage automatic memory, statistics, and SQL tuning.

~9%

Upgrading and patching

Run AutoUpgrade in analyze and deploy modes, the preupgrade tool, OPatch and OPatchAuto, datapatch SQL patching, online patching, and unplug-plug PDB upgrades, always backing up first.

~20%

Auditing, security, diagnostics, and data movement

Configure Unified Auditing policies and privilege analysis, secure multitenant databases, browse the ADR with ADRCI and the alert log, transport tablespaces across platforms, and duplicate databases with RMAN.

How to Pass the Oracle Database Administration II Exam

What You Need to Know

  • Passing score: Approximately 60% (Oracle does not publish the exact percentage)
  • Assessment: Question count not published by the exam provider
  • Time limit: 150 minutes
  • Exam fee: $245

Keys to Passing

  • Work through all 100 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

Oracle Database Administration II Study Tips from Top Performers

1Get hands-on in a real CDB: create, clone (hot and cold), unplug, plug, and relocate PDBs, and watch V$PDBS and PDB_PLUG_IN_VIOLATIONS so multitenant scenario answers become intuitive.
2Spend the most time on RMAN: practice CONFIGURE retention and autobackup, level 0 and level 1 incrementals, RESTORE/RECOVER of datafiles and control files, RESTORE PREVIEW, and database and PDB point-in-time recovery.
3Memorize when each Flashback feature applies: Flashback Database needs ARCHIVELOG plus an FRA and a MOUNTED database, Flashback Drop uses the recycle bin, and Flashback Table needs row movement enabled.
4Learn AutoUpgrade thoroughly: the difference between analyze and deploy modes, the config file entries like target_home, and the role of the preupgrade tool, OPatch, and datapatch.
5Practice diagnosing performance with AWR reports, ADDM findings, and ASH, and know what SQL profiles, SQL Plan Management baselines, and the SQL Tuning and SQL Access advisors each do.
6Review security and diagnostics: create Unified Auditing policies and query UNIFIED_AUDIT_TRAIL, run privilege analysis, apply lockdown profiles, and browse the alert log and incidents with ADRCI.

Frequently Asked Questions

What are the current exam facts for 1Z0-083?

Oracle lists 1Z0-083, Oracle Database Administration II, as the second OCP exam delivered through Pearson VUE for about $245 USD. It typically presents around 80 multiple-choice and multiple-select questions in 150 minutes, with a passing score near 60 percent.

Is 1Z0-083 specific to Oracle Database 21c?

No. The 1Z0-083 exam is version-agnostic and validates Oracle Database administration skills across both 19c and 21c. There is no separate 21c-only OCP exam; 1Z0-083 covers the multitenant, RMAN, Flashback, tuning, and upgrade features common to those releases.

Which topics carry the most weight on 1Z0-083?

Multitenant architecture and backup and recovery with RMAN are the heaviest areas, together with database upgrades. Oracle and many candidates report that CDB and PDB management, RMAN restore and recovery, and AutoUpgrade questions dominate the exam.

How do I earn the OCP credential with this exam?

The Oracle Database Administration Certified Professional (OCP) credential requires passing both Oracle Database Administration I (1Z0-082) and Oracle Database Administration II (1Z0-083). 1Z0-083 is the second exam in that two-exam path.

Does the OCP credential expire?

No. Once earned, the Oracle Database Administration Certified Professional credential does not expire, though Oracle periodically retires older exam versions as new database releases are introduced.

What is the best way to prepare for 1Z0-083?

Build a lab with a CDB and PDBs and practice creating, cloning, and relocating PDBs, configuring RMAN, and performing point-in-time and PDB recovery. Then drill Flashback, AutoUpgrade analyze and deploy modes, AWR and ADDM analysis, and Unified Auditing until the commands feel routine.