Free diagnostic practice
Oracle PL/SQL Developer Certified Professional
The Oracle PL/ Developer Certified Professional certification validates a candidate's ability to design, implement, and optimize complex procedural logic within the Oracle Database ecosystem
- 90 min
- 66% to pass
- 65 bank questions
- 7 domains
certilumExam syllabus, organized by domain
The official Oracle blueprint, with the real weight each domain carries on test day.
Try a real question
Answer one question from the live bank. Grading happens on our servers, so the answer key never reaches the page.
Try a real question
Sample Oracle PL/SQL Developer Certified Professional exam question
Answer this question the same way you would on exam day. No sign-up needed — one random question, three tries to swap it out.
When using EXECUTE IMMEDIATE for a single-row dynamic query, which clause is mandatory to store the result?
Exam facts at a glance
Every figure below comes from the certification record or from the question bank itself.
- Time limit
- 90 minutes
- Passing score
- 66%
- Domains
- 7
- Questions in our bank
- 65
- Level
- PROFESSIONAL
- Measured complexity
- 1.9 / 10
- Question mix
- 25 single · 20 multi · 20 interactive
Where the hard questions actually are
We score every question in the bank 1-10 on a reproducible formula. Below is the per-domain breakdown.
- Code Management6 questions · complexity 2.7/10 · Gentle
50% multi-select · 0% scenario · 33% interactive
- Dynamic SQL and Advanced Topics10 questions · complexity 1.8/10 · Gentle
30% multi-select · 0% scenario · 30% interactive
- Exception Handling6 questions · complexity 2.0/10 · Gentle
33% multi-select · 0% scenario · 33% interactive
- PL/SQL Fundamentals10 questions · complexity 1.8/10 · Gentle
30% multi-select · 0% scenario · 30% interactive
- SQL in PL/SQL7 questions · complexity 1.7/10 · Gentle
29% multi-select · 0% scenario · 29% interactive
- Subprograms and Packages16 questions · complexity 1.9/10 · Gentle
31% multi-select · 0% scenario · 31% interactive
- Working with Data10 questions · complexity 1.8/10 · Gentle
30% multi-select · 0% scenario · 30% interactive
Read the questions before you take them
The question bank with the correct answer and a written explanation for every item.
Frequently asked questions
What you need to know before attempting the Oracle PL/SQL Developer Certified Professional certification.
Compare related certifications
Related articles
Salesforce Certified Administrator (Plat-Admn-201): Format, Domains and Cost
The current Salesforce administrator exam code is Plat-Admn-201, not ADM-201. Here is the eight-domain blueprint, the format, the price and what to focus on when you sit down.
AWS Certified Developer Associate Certification DVA-C02
Master the AWS Certified Developer – Associate Certification (DVA-C02): exam structure, 65 questions, 130 mins, USD 150 fee, and domain weights.