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
| 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
| 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?
- A SEED FILE_NAME_CONVERT = NONE
- B CONTAINER = ALL
- C LOCAL UNDO ON
- D ENABLE PLUGGABLE DATABASE (correct answer)
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 (correct answer)
- D CDB_PDB_HISTORY
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 (correct answer)
- D Plug it in with NOCOPY and query V$PDBS for a RESTRICTED value of NO
See all 10 free 1Z0-083 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, 1Z0-083 practice test 3
77%
Passed
Pass mark 57%
| Domain | Weight | Your 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.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- 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.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- 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.
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 |