If you build cloud‑native apps, aim for the OCI Developer Professional; if your day‑to‑day is database code and tuning, follow the SQL/PL/SQL track; if you’re a Java engineer, pick the Java SE progression. This article lists the likely exam codes, formats, registration steps, costs, and a copy‑ready study plan you can follow to pass.
At CloudShine we’ve trained 500+ consultants, and the roadmap below is the practical checklist we give every student before their exam.
Pick the right path for your role (quick decision map)
Match the tasks you perform, not the job title on your résumé. The right credential proves you can do the job; the wrong one wastes time and interview bandwidth.
Cloud‑native application developer
Target: Oracle Cloud Infrastructure (OCI) Developer Professional (cloud functions, OKE, CI/CD, Terraform). Example resume line: “OCI Developer — deployed containerized services to OKE and automated pipelines with Terraform.”
Database / application developer
Target: Database SQL + PL/SQL curriculum (Oracle Database SQL Certified Associate and PL/SQL developer pathway). Example line: “Database Developer — authored PL/SQL packages and tuned complex queries.”
Backend / enterprise Java developer
Target: Java SE Associate → Professional track (core language, concurrency, streams, modules). Example line: “Java SE Developer — multithreading, streams, and module system.”
Low‑code / citizen developer
Target: Oracle APEX or Redwood developer tags for low‑code app builders and UX‑driven work.
Practical decision checklist — ask yourself: 1) What do I build daily? 2) What do employers in my market hire for? 3) How quickly do I need a credential (6 months or less)? If unsure, pick the smallest certification that proves you can do the job you want within six months.
What the major exams test: codes, format, duration, and passing score
Oracle updates exam names and codes; always verify the current code and objectives on Oracle’s Certification Browser before you buy an attempt. Below are the common developer tracks and what to expect.
OCI Developer Professional (example code)
Typical listing (as of 2026): Oracle Cloud Infrastructure Developer Professional — 1Z0‑1084‑26 (confirm on Oracle’s site: OCI Developer Professional track page). The exam focuses on cloud‑native app design, containers, DevOps automation, security, and observability. For integration-focused topics see our Oracle Integration Cloud Service Certification: Your Ultimate Guide, which covers common integration patterns and exam-relevant concepts.
Domain split (typical): cloud‑native dev ~25%; containers/OKE ~20%; DevOps automation (Terraform, CI/CD) ~20%; security & integration ~20%; monitoring/troubleshooting ~15%. Format is scenario‑based multiple choice (roughly 60–70 questions), 90 minutes, passing score ~68%. Common gotcha: questions expect applied decisions (architecture/troubleshooting) rather than memorized API names.
Database SQL / PL/SQL tracks
SQL Certified Associate (1Z0‑071 historically) covers core SQL: queries, joins, DML, and performance basics. PL/SQL topics live in database developer paths and practical labs; Oracle often expects demonstration of stored procedures, packages, and performance tuning. Format is multiple choice with scenario questions; hands‑on competency is validated via labs and projects rather than a single practical lab exam in most cases.
Java SE (Associate → Professional)
Historical exam codes include the 1Z0‑808 family for Java SE 8 and updated codes for SE 11/17/21; consult Oracle’s browser. Expect core language, OOP, collections, streams, concurrency and modules. Format: multiple choice; focus on applied questions (choose correct output, thread behaviour, API misuse). For a helpful overview of the Java certification landscape and where each credential fits, see this Java certifications guide.
How to verify objectives quickly: open Oracle’s Certification Browser → search the certification name → read the exam guide/skills measured PDF. Treat the official objectives as your checklist for hands‑on labs and practice tests.
Costs, registration, proctoring, retakes and exam‑day logistics
Buy exam attempts through Oracle University/MyLearn. Most exams are online‑proctored; pricing varies by region and exam level—check the exam page for precise costs before purchase. Oracle maintains a central developer-certifications hub with course and purchasing links on the official site: Oracle developer certifications.
- Purchase a single exam attempt or a Learning Subscription on education.oracle.com and accept the Candidate Agreement.
- Link your Oracle account to the scheduling tool (MyLearn/CertView) and, if required, to Pearson VUE IDs.
- Schedule your test inside the allowed window (commonly six months) and choose online proctoring or a Pearson VUE center if available in your region.
- Follow ID and environment rules exactly (photo ID, clear desk, no external devices); some regions have export restrictions—confirm ahead of time.
Learning Subscriptions can include multiple exam attempts and official practice tests, which often lowers per‑exam cost if you anticipate a retake. If you fail, use the score report to target weak domains, remediate with focused labs, and retake after 2–4 weeks of revision. For recent guidance on exam pricing and what to expect to pay, Oracle University published a helpful breakdown: what it costs to get Oracle certified.
Exam‑day checklist (48–72 hours before): run the proctoring system check, confirm your ID matches registration, clear and quiet workspace, have a backup test date, and spend the final 24–48 hours on light review of domain keywords and one untimed lab—not last‑minute cramming.
A practical study plan you can copy (OCI, PL/SQL, Java)
Measure readiness by practice test scores + completed labs, not hours. Use project‑based learning and timed mock exams to simulate the test environment.
- Week 0 (setup): create an Oracle Free Tier account, install OCI CLI, push a sample repo to Git (6–8 hours).
- Weeks 1–2: Functions & API Gateway — build a sample function and secure it behind API Gateway; automate calls from a CI job (8–10 hrs/week).
- Weeks 3–4: Containers & OKE — containerize an app, push to OCIR, deploy to OKE, and introduce a basic service mesh (8–10 hrs/week).
- Week 5: DevOps automation — author Terraform modules and build a CI/CD pipeline that deploys to OKE/Functions (8–10 hrs).
- Week 6: Security & integration — implement IAM policies, secrets management (Vault), and secure endpoints (6–8 hrs).
- Week 7: Observability — configure logging and metrics; run a mock incident and trace it to root cause (6–8 hrs).
- Week 8: Exam prep — two timed practice tests, final lab review; pass criteria: 80%+ on practice tests and three completed labs.
PL/SQL condensed (4–6 weeks): focus weeks on SQL fundamentals, procedural PL/SQL, packages & exception handling, and a final project of three stored procedures with test cases. Java condensed (4–6 weeks): core language refresh, streams & concurrency, modules, then two small projects and timed mock tests.
CloudShine add‑on: our cohorts provide live Oracle instances, hands‑on lab time, and mentorship that can compress these plans by 20–40% through guided labs and targeted mock interviews. If you need help with migration strategy or implementation best practices while preparing for Cloud exams, check our guide on Oracle Cloud Implementation Best Practices.
The best official and third‑party resources (what to buy, what’s free, what to skip)
Official first: Oracle University course pages and the exam guide are the syllabus authority; Oracle free digital training and Oracle Live Labs/Free Tier are essential for hands‑on practice. Use the official practice exam from Oracle University where available to validate timing and question style. If you prefer an instructor‑led approach, an instructor‑led course can accelerate progress for less experienced candidates.
Third‑party: reputable practice test providers are useful for timing and exam rhythm—aim for 80%+ on high‑quality mock exams before scheduling. Use targeted Udemy/Pluralsight courses for weak spots and GitHub sample projects or community blogs for applied examples. Avoid “dumps” or unverified question banks that violate exam policies.
Prep stack by persona: a Pivoter (experienced pro) should pair official docs + 2 labs/week + paid practice tests + mentor review. An Aspirant (recent grad) benefits from a structured instructor‑led course, live instances, and weekly mentor check‑ins. If you’re mapping a career switch into enterprise apps, our article on the path to becoming an Oracle Fusion Consultant outlines typical roles and skill gaps employers expect.
CloudShine note: we provide 100% practical labs, expert mentors (15+ years), resume polishing, and mock interviews to get you interview‑ready, not just exam‑ready. To discuss whether you should engage a partner for implementation or hiring support, book a short consult and we’ll map options for your market and timeline.
FAQs (short) and a 3‑step action plan
Which cert should I take first?
Pick the certificate that proves the job you want: OCI for cloud dev, SQL/PLSQL for database dev, Java SE for core software engineering.
How long to prepare?
Depends on experience: 6–12 weeks for OCI with 8–12 hrs/week and completed labs; 4–8 weeks for focused PL/SQL or Java refreshers.
How much do exams cost?
Costs vary by region and level; check the Oracle exam page at purchase. Learning Subscriptions often include multiple attempts and can reduce per‑exam cost if you plan to retake.
Are hands‑on labs required?
Most developer roles expect demonstrable hands‑on skills—build 2–3 projects you can demo in interviews.
Do certifications expire?
Oracle updates tracks; consult the exam page and certification policies for recertification or migration paths.
3‑step action plan: 1) Confirm the exact exam code on Oracle’s Certification Browser. 2) Follow the relevant study plan above (or join a CloudShine practical cohort) and only schedule the exam once you hit 80%+ on practice tests and finish the labs. 3) Run two mock interviews, polish your resume with project bullets, then take the exam.
Final recap: pick the smallest certification that demonstrates the job you want, prioritize hands‑on labs and timed mocks, and treat practice tests as your readiness gauge. If you want help compressing this plan and landing the job, CloudShine runs practical OCI/PLSQL/Java bootcamps with live instances and placement support—book a short consult to map your personalized 8‑week plan.
