Certification blueprints change, and Test4Cram keeps pace: every 1Z0-083 purchase includes 365 days of free updates, so your 283 practice questions stay aligned with the current Oracle Database Administration II in 2026 and beyond.
Oracle 1Z0-083 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database Administration II |
| Exam Number: | 1Z0-083 |
| Passing Score: | 57% |
| Exam Format: | Multiple Choice, Multiple Select |
| Real Exam Qty: | 68 |
| Certificate Validity Period: | Version-specific |
| Exam Duration: | 120 minutes |
| Available Languages: | English |
| Related Certifications: | Oracle Database Administration Certified Associate Oracle Database Administration 2019 Certified Professional |
| Exam Price: | USD 245 |
| Sample Questions: | ![]() |
| Exam Way: | Pearson VUE testing center or Oracle online proctored exam. |
| Pre Condition: | Oracle Database Administration Certified Associate credential is recommended before pursuing the Professional certification. |
| Official Syllabus URL: | https://education.oracle.com/oracle-database-administration-ii/pexam_1Z0-083 |
Oracle 1Z0-083 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Database Duplication and Migration | - Database Duplication
|
| Security in Multitenant Databases | - User and Privilege Management
|
| Performance Monitoring and Tuning | - Performance Monitoring
|
| Creating CDBs and Regular PDBs | - Configure and create a CDB
|
| Database Upgrades and Patching | - Upgrade Operations
|
| Backup and Recovery | - Restore and Recovery
|
| Managing CDBs and PDBs | - PDB Lifecycle Operations
|
1Z0-083 Exam FAQ: Prep, Registration, and Policies Explained
Yes. Test4Cram offers a free PDF demo of the 1Z0-083 practice questions so you can check the quality, the format, and the difficulty level before you spend anything. After you purchase, you also receive 365 days of free updates, and if the product expires you can extend the update service at a 50% discount from your member zone.
The 1Z0-083 exam contains 68 questions and gives you 120 minutes to complete them. That works out to a brisk pace, so you cannot afford to stall on a single tricky item — flag it, move on, and circle back if time allows. Before exam day, run at least two timed mock sessions with the Test4Cram desktop or online test engine; practicing against a real clock turns the official time limit into a comfortable rhythm instead of a source of panic.
The 1Z0-083 exam (full name: Oracle Database Administration II) is a Oracle certification exam that leads to the Oracle Database 19c credential, positioned at the Professional level. It validates the skills Oracle expects from professionals working with its technologies, and passing it is the key step toward getting certified. It also sits within a broader certification path that includes Oracle Database Administration 2019 Certified Professional, Oracle Database Administration Certified Associate.
The Oracle Database Administration II exam is organized into 7 domains. The main areas include Performance Monitoring and Tuning, Database Duplication and Migration, and Backup and Recovery. Scroll up to the exam syllabus section on this page for the complete topic-by-topic outline.
Oracle Database Administration Certified Associate credential is recommended before pursuing the Professional certification.
Eligibility requirements can change, so before you register, confirm the latest criteria on the official Oracle exam page.
To pass the 1Z0-083 exam you need a score of 57%, and the official registration fee is USD 245. Keep in mind that a failed attempt comes at full price: retaking the exam means paying the entire fee again. A smart way to protect that investment is to self-test first — work through the 283 practice questions at Test4Cram until your timed scores sit comfortably above the passing line before you book a seat.
Delivery is instant: you can download your purchase right after payment, and a copy is sent to your email within one minute. If nothing arrives within 2 hours, check your spam folder and contact our support team. There is no limit on how many computers you can install the software on.
If you take the 1Z0-083 exam within 60 days of your purchase and do not pass, you can apply for a full refund under the Test4Cram money back guarantee. To file a claim, submit a scan of your exam enrollment slip together with the official score report (PDF) within 2 days of taking the exam, and your claim will be processed within 7 days. The candidate name must match the payer name, and the policy does not apply to exams taken within 3 days of purchase, to purchases where the exam was never actually taken, or to free materials and expired orders. Prefer an alternative? Instead of a refund, you can exchange your purchase for two free exam products of equal value while keeping the update service on your original product.
Oracle Database Administration II Sample Questions:
In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?
- A. mandatory Oracle-supplied PL/SQL packages
- B. control files
- C. user-defined PL/SQL packages
- D. undo tablespaces
- E. redo logs
- F. all data dictionary metadata
- G. temporary tablespaces
Correct Answer: B,E,F 🗳️
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)
- A. CDB1 and CDB2 must be in shared undo mode.
- B. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
- C. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
- D. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
- E. Cloning HR_ROOT automatically clones HR_PDB1.
Correct Answer: C,D 🗳️
Explanation: Only visible for Test4Cram members. You can sign-up / login (it's free).
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)
- A. Poorly performing SQL statements can be tuned automatically by the Oracle server.
- B. SQL statements doing joins always do more physical I/O than single table queries.
- C. SQL statements doing only logical reads never require tuning because they do no physical I/O.
- D. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
- E. The solution that best optimizes one SQL statement can degrade the performance of others.
Correct Answer: A,E 🗳️
Explanation: Only visible for Test4Cram members. You can sign-up / login (it's free).
For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?
- A. to generate an XML metadata file that describes the current plugged-in PDB
- B. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure
- C. to generate an XML metadata file from any unplugged PDB
- D. to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB
- E. to generate a . pdb archive file for any PDB in the current CDB
Correct Answer: A,D 🗳️
A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2.
You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.
Which three are required?
- A. CDB2 must be in archivelog mode.
- B. CDB1 and CDB2 must be in shared UNDO mode.
- C. CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
- D. CDB1 must be in archivelog mode.
- E. CDB2 must be in shared UNDO mode only.
- F. CDB1 and CDB2 must both be in local UNDO mode.
Correct Answer: A,D,F 🗳️
Viewing page 1 out of 57 pages.
Viewing questions 1-5 out of 283 questions.


