# Oracle DBA II 1Z0-083 practice exams

> 5 timed 1Z0-083 practice tests with 290 questions and a 57% pass mark. See your score in Creating and Restore and every other domain.

Page: https://devopscodelab.com/exams/oracle-1z0-083/

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

| Setting | Value |
| --- | --- |
| 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 format before you book.

## Domains and weights

| Domain | Weight | 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 |

## Price and access

- 1Z0-083 practice exams: $14.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/oracle-1z0-083/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/oracle-1z0-083/free-practice-questions/

## 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?

- A. SEED FILE_NAME_CONVERT = NONE
- B. CONTAINER = ALL
- C. LOCAL UNDO ON
- D. ENABLE PLUGGABLE DATABASE

**Answer:** D

**Explanation:** 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?

- A. DBA_CONTAINER_DATA
- B. DBA_PDBS
- C. V$PDBS
- D. CDB_PDB_HISTORY

**Answer:** C

**Explanation:** 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?

- A. Run the preupgrade.jar tool against the XML manifest to list blocking issues
- B. Run DBMS_PDB.DESCRIBE on the XML file and query DBA_PDB_HISTORY
- C. Run DBMS_PDB.CHECK_PLUG_COMPATIBILITY and review PDB_PLUG_IN_VIOLATIONS
- D. Plug it in with NOCOPY and query V$PDBS for a RESTRICTED value of NO

**Answer:** C

**Explanation:** 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.


## 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.

DevOpsCode Lab is not affiliated with Oracle. 1Z0-083 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
