1Z0-083

Oracle DBA II 1Z0-083 practice exams

290 questions in 5 timed practice tests. Each test has about 60 questions and a 110-minute limit. The pass mark is 57%. Results are split across the 7 exam domains.

Exam at a glance

1Z0-083 practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 60
Time limit per test 110 minutes
Pass mark 57%
Question types Single answer and multiple answer (29 multiple-answer questions)
Level Professional
Category Data & Analytics

These are the settings of our practice tests. Check the official Oracle exam page for the current exam format before you book.

Domains and weights

1Z0-083 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Creating and Managing CDBs and PDBs 20% 58
Application Containers, Multitenant Security and PDB Mobility 15% 44
Backup Strategies, RMAN Backups and Database Duplication 17% 49
Restore, Recovery and Flashback Technologies 18% 52
Installation, Patching, Upgrades and Oracle Restart 12% 35
Performance Monitoring and SQL Tuning 10% 29
Oracle Database 18c and 19c Enhancements 8% 23

Sample questions

Question 1 of 3

A DBA manually creates a new CDB with CREATE DATABASE. Which clause makes the new database a multitenant container database?

  1. A SEED FILE_NAME_CONVERT = NONE
  2. B CONTAINER = ALL
  3. C LOCAL UNDO ON
  4. D ENABLE PLUGGABLE DATABASE (correct answer)
Why: ENABLE PLUGGABLE DATABASE in CREATE DATABASE creates CDB$ROOT and PDB$SEED and makes the database a CDB. CONTAINER=ALL is used for parameters, users and grants, LOCAL UNDO ON chooses the undo mode of an existing CDB definition, and SEED FILE_NAME_CONVERT only names seed files and is valid only together with ENABLE PLUGGABLE DATABASE.

Question 2 of 3

Which view, queried from CDB$ROOT, shows the open mode and restricted status of every PDB in the current instance?

  1. A DBA_CONTAINER_DATA
  2. B DBA_PDBS
  3. C V$PDBS (correct answer)
  4. D CDB_PDB_HISTORY
Why: V$PDBS reports the per-instance open mode, restricted flag and other runtime state of each PDB. DBA_PDBS shows dictionary status such as NORMAL or UNPLUGGED rather than the open mode, CDB_PDB_HISTORY records lineage such as creation and plugging events, and DBA_CONTAINER_DATA lists which containers common users may see data for.

Question 3 of 3

Before plugging an unplugged PDB described by /stage/hr.xml into a new CDB, the DBA wants to know whether it is compatible. Which approach is recommended?

  1. A Run the preupgrade.jar tool against the XML manifest to list blocking issues
  2. B Run DBMS_PDB.DESCRIBE on the XML file and query DBA_PDB_HISTORY
  3. C Run DBMS_PDB.CHECK_PLUG_COMPATIBILITY and review PDB_PLUG_IN_VIOLATIONS (correct answer)
  4. D Plug it in with NOCOPY and query V$PDBS for a RESTRICTED value of NO
Why: DBMS_PDB.CHECK_PLUG_COMPATIBILITY returns whether the manifest is compatible and records details in PDB_PLUG_IN_VIOLATIONS. DESCRIBE generates a manifest from a non-CDB rather than checking one, plugging in first does the change before checking, and preupgrade.jar analyses a database for upgrade, not a manifest for plug compatibility.

What your score report looks like

Example attempt, 1Z0-083 practice test 3

77%

Passed
Pass mark 57%

Score by exam domain
DomainWeightYour score%
Creating and Managing CDBs and PDBs 20%
88
Application Containers, Multitenant Security and PDB Mobility 15%
81
Backup Strategies, RMAN Backups and Database Duplication 17%
76
Restore, Recovery and Flashback Technologies 18%
58
Installation, Patching, Upgrades and Oracle Restart 12%
84
Performance Monitoring and SQL Tuning 10%
72

Study next: Restore, Recovery and Flashback Technologies. It is below the pass mark and carries 18% of the exam.

Domains and pass mark from our 1Z0-083 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Creating and Managing CDBs and PDBs and Restore, Recovery and Flashback Technologies, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the 1Z0-083 practice exams

Are these real 1Z0-083 exam questions?
No. We write every question ourselves and map it to the published 1Z0-083 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Oracle. 1Z0-083 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
1Z0-1085-26OCI Foundations 1Z0-1085-26 Oracle Foundational 200 60 $9.99
1Z0-1122-26OCI AI Foundations 1Z0-1122-26 Oracle Foundational 300 90 $9.99
DP-900Azure Data Fundamentals DP-900 Microsoft Foundational 225 45 $9.99
SPLK-1001Splunk Core Certified User (SPLK-1001) Splunk Foundational 300 60 $9.99
A00-231SAS Base Programming A00-231 SAS Associate 300 135 $12.99
COF-C03SnowPro Core COF-C03 Snowflake Associate 300 70 $12.99