All Practice Exams
100+ Free Oracle Database Administration II Practice Questions
Oracle Database Administration II (1Z0-083) practice questions are available now; exam metadata is being verified.
✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0
You need to recover a single PDB to a point in time without affecting other PDBs in the CDB. Which statement is true about PDB point-in-time recovery in Oracle 19c?
A
B
C
D
to track
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.
More From This Family
Videos and articles for deeper review.
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 Practice Questions
Verified exam format metadata for Oracle Database Administration II (1Z0-083) is pending. The practice questions above remain available while official exam length, timing, passing score, fee, and administrator details are reviewed.