Oracle Certification Guides

This section collects the current Oracle certification roots on TechExamLexicon.com across SQL, Java, OCI, MySQL, Autonomous Database, analytics, migration, observability, networking, multicloud, and AI-related tracks. The published content is still support-heavy, but the vendor root now exists as a proper branch bundle so each exam can expand into a fuller guide without a later URL migration.

Published roots currently include 1Z0-071, 1Z0-1042-25, 1Z0-1067-25, 1Z0-1072-25, 1Z0-1084-25, 1Z0-1085-25, 1Z0-1093-25, 1Z0-1104-25, 1Z0-1109-25, 1Z0-1110-25, 1Z0-1111-25, 1Z0-1122-25, 1Z0-1123-25, 1Z0-1124-25, 1Z0-1127-25, 1Z0-1151-25, 1Z0-1195-25, 1Z0-829, 1Z0-830, 1Z0-908, 1Z0-909, 1Z0-931-25, and 1Z0-997-25. Start with the exact exam code you are targeting, then use the study plan when it exists, the cheat sheet for last-mile review, the FAQ for recurring questions, and the resources page for official references.

In this section

• Oracle 1Z0-071 Certification Guide
  Study hub for Oracle 1Z0-071 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-071 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for Oracle Database SQL (1Z0-071): recommended hours, weekly schedules, and practice integration.
  • 1Z0-071 Cheatsheet — Oracle SQL: Joins, NULLs, Aggregations, Subqueries
    Last-mile 1Z0-071 review: high-yield Oracle SQL rules and examples for joins, NULL semantics, grouping/aggregation, subqueries, set operators, and DDL/DML basics.
  • 1Z0-071 FAQ — Oracle Database SQL
    Frequently asked questions for Oracle Database SQL (1Z0-071): difficulty, prerequisites, and what to focus on.
• Oracle 1Z0-1042-25 Certification Guide
  Study hub for Oracle 1Z0-1042-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1042-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Application Integration Professional (1Z0-1042-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1042-25 Cheatsheet — OCI App Integration (API Gateway, Events, Functions)
    Last-mile 1Z0-1042-25 review: API Gateway patterns, event-driven integration pickers, Functions glue code, reliability guardrails, and observability checklists.
  • 1Z0-1042-25 FAQ — OCI Application Integration Professional
    Frequently asked questions for OCI 2025 Application Integration Professional (1Z0-1042-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1067-25 Certification Guide
  Study hub for Oracle 1Z0-1067-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1067-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Cloud Ops Professional (1Z0-1067-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1067-25 Cheatsheet — OCI Cloud Ops (Monitoring, Logging, Automation)
    Last-mile 1Z0-1067-25 review: monitoring and alarm patterns, logging and audit workflow, automation guardrails, and incident response checklists.
  • 1Z0-1067-25 FAQ — OCI Cloud Ops Professional
    Frequently asked questions for OCI 2025 Cloud Ops Professional (1Z0-1067-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1072-25 Certification Guide
  Study hub for Oracle 1Z0-1072-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1072-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Architect Associate (1Z0-1072-25): recommended hours, weekly schedules, and how to integrate practice.
  • 1Z0-1072-25 Cheatsheet — OCI Architect Associate (Networking, LB, Compute/Storage)
    Last-mile 1Z0-1072-25 review: VCN design pickers, connectivity options, load balancing patterns, compute/storage/database selection, HA basics, and observability.
  • 1Z0-1072-25 FAQ — OCI Architect Associate
    Frequently asked questions for OCI 2025 Architect Associate (1Z0-1072-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1084-25 Certification Guide
  Study hub for Oracle 1Z0-1084-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1084-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Developer Professional (1Z0-1084-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1084-25 Cheatsheet — OCI Developer Professional (Auth, APIs, Functions, Events)
    Last-mile 1Z0-1084-25 review: OCI auth patterns (API keys, instance/resource principals), API/SDK/CLI usage, Functions and event-driven design, and operational safety rules.
  • 1Z0-1084-25 FAQ — OCI Developer Professional
    Frequently asked questions for OCI 2025 Developer Professional (1Z0-1084-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1085-25 Certification Guide
  Study hub for Oracle 1Z0-1085-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1085-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Foundations Associate (1Z0-1085-25): recommended hours, weekly schedules, and how to integrate practice.
  • 1Z0-1085-25 Cheatsheet — OCI Foundations (Tenancy, IAM, Networking, Core Services)
    Last-mile 1Z0-1085-25 review: OCI tenancy model, IAM basics, VCN networking basics, compute/storage pickers, observability, and governance/pricing.
  • 1Z0-1085-25 FAQ — OCI Foundations Associate
    Frequently asked questions for OCI 2025 Foundations Associate (1Z0-1085-25): difficulty, prerequisites, what to study, and how to use the syllabus.
• Oracle 1Z0-1093-25 Certification Guide
  Study hub for Oracle 1Z0-1093-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1093-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for Oracle AI Cloud Database Services 2025 Professional (1Z0-1093-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1093-25 Cheatsheet — Database Service Selection, Security, Backup/Recovery & Ops
    Last-mile 1Z0-1093-25 review: database service selection pickers, secure provisioning checklist, backup/recovery rules, migration cues, and monitoring/ops fundamentals.
  • 1Z0-1093-25 FAQ — Oracle AI Cloud Database Services 2025 Professional
    Frequently asked questions for Oracle AI Cloud Database Services 2025 Professional (1Z0-1093-25): prerequisites, difficulty, and study strategy.
• Oracle 1Z0-1104-25 Certification Guide
  Study hub for Oracle 1Z0-1104-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1104-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Security Professional (1Z0-1104-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1104-25 Cheatsheet — OCI Security Professional (IAM, Vault, Cloud Guard)
    Last-mile 1Z0-1104-25 review: IAM/policy patterns, compartment scope, Vault/KMS decision rules, network security controls, Cloud Guard posture and response, and audit/logging essentials.
  • 1Z0-1104-25 FAQ — OCI Security Professional
    Frequently asked questions for OCI 2025 Security Professional (1Z0-1104-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1109-25 Certification Guide
  Study hub for Oracle 1Z0-1109-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1109-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 DevOps Professional (1Z0-1109-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1109-25 Cheatsheet — OCI DevOps Professional (CI/CD, IaC, Release Strategy)
    Last-mile 1Z0-1109-25 review: CI/CD pipeline mental models, Terraform/Resource Manager rules, blue/green vs canary pickers, secrets handling, and observability/rollback cues.
  • 1Z0-1109-25 FAQ — OCI DevOps Professional
    Frequently asked questions for OCI 2025 DevOps Professional (1Z0-1109-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1110-25 Certification Guide
  Study hub for Oracle 1Z0-1110-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1110-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Data Science Professional (1Z0-1110-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1110-25 Cheatsheet — OCI Data Science (Lifecycle, Deployments, MLOps)
    Last-mile 1Z0-1110-25 review: OCI Data Science objects, training/evaluation reminders, deployment patterns, monitoring checklists, and governance guardrails.
  • 1Z0-1110-25 FAQ — OCI Data Science Professional
    Frequently asked questions for OCI 2025 Data Science Professional (1Z0-1110-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1111-25 Certification Guide
  Study hub for Oracle 1Z0-1111-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1111-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Observability Professional (1Z0-1111-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1111-25 Cheatsheet — OCI Observability (Metrics, Logs, Traces)
    Last-mile 1Z0-1111-25 review: metrics/logs/traces pickers, alert design rules, dashboards, log hygiene, and incident triage workflow.
  • 1Z0-1111-25 FAQ — OCI Observability Professional
    Frequently asked questions for OCI 2025 Observability Professional (1Z0-1111-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1122-25 Certification Guide
  Study hub for Oracle 1Z0-1122-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1122-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 AI Foundations Associate (1Z0-1122-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1122-25 Cheatsheet — AI Fundamentals, Metrics, GenAI Basics & Responsible AI
    Last-mile 1Z0-1122-25 review: AI/ML lifecycle, evaluation metrics pickers, leakage/overfitting rules, GenAI grounding intuition, and responsible AI checklists.
  • 1Z0-1122-25 FAQ — OCI AI Foundations Associate
    Frequently asked questions for OCI 2025 AI Foundations Associate (1Z0-1122-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1123-25 Certification Guide
  Study hub for Oracle 1Z0-1123-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1123-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Migration Architect Professional (1Z0-1123-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1123-25 Cheatsheet — OCI Migration Architect (Connectivity, Cutover, Validation)
    Last-mile 1Z0-1123-25 review: migration phases, connectivity pickers (VPN/FastConnect), cutover decision tables, validation checklist, and rollback planning.
  • 1Z0-1123-25 FAQ — OCI Migration Architect Professional
    Frequently asked questions for OCI 2025 Migration Architect Professional (1Z0-1123-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1124-25 Certification Guide
  Study hub for Oracle 1Z0-1124-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1124-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Networking Professional (1Z0-1124-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1124-25 Cheatsheet — OCI Networking (VCN, DRG, Routing, Security)
    Last-mile 1Z0-1124-25 review: VCN and subnet patterns, DRG hub-and-spoke pickers, routing table reminders, and security list vs NSG decision tables.
  • 1Z0-1124-25 FAQ — OCI Networking Professional
    Frequently asked questions for OCI 2025 Networking Professional (1Z0-1124-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1127-25 Certification Guide
  Study hub for Oracle 1Z0-1127-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1127-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Generative AI Professional (1Z0-1127-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1127-25 Cheatsheet — RAG, Evaluation, Safety, Deployment & Cost Control
    Last-mile 1Z0-1127-25 review: RAG pipeline, chunking and embeddings pickers, evaluation signals, prompt injection defenses, deployment patterns, and cost/latency controls.
  • 1Z0-1127-25 FAQ — OCI Generative AI Professional
    Frequently asked questions for OCI 2025 Generative AI Professional (1Z0-1127-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1151-25 Certification Guide
  Study hub for Oracle 1Z0-1151-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-1151-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Multicloud Architect Professional (1Z0-1151-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1151-25 Cheatsheet — OCI Multicloud Architect Professional (Connectivity, Federation, Data)
    Last-mile 1Z0-1151-25 review: multicloud connectivity pickers, identity federation patterns, data placement/replication trade-offs, and governance/security checklists.
  • 1Z0-1151-25 FAQ — OCI Multicloud Architect Professional
    Frequently asked questions for OCI 2025 Multicloud Architect Professional (1Z0-1151-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-1195-25 Certification Guide
  Study hub for Oracle 1Z0-1195-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-1195-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for Oracle Data Platform 2025 Foundations Associate (1Z0-1195-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-1195-25 Cheatsheet — Ingestion, Lakes/Warehouses, Governance & Analytics
    Last-mile 1Z0-1195-25 review: data platform layers, ingestion pickers (batch/streaming/CDC), processing/ETL rules, catalog/governance checklists, and cost/ops cues.
  • 1Z0-1195-25 FAQ — Oracle Data Platform Foundations Associate
    Frequently asked questions for Oracle Data Platform 2025 Foundations Associate (1Z0-1195-25): prerequisites, difficulty, and what to focus on.
• Oracle 1Z0-829 Certification Guide
  Study hub for Oracle 1Z0-829 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-829 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for Java SE 17 Developer (1Z0-829): recommended hours, weekly schedules, and practice integration.
  • 1Z0-829 Cheatsheet — Java SE 17 (Language, Generics, Streams, Concurrency)
    High-yield 1Z0-829 cheat sheet for Java SE 17: rules, APIs, patterns, and pitfalls across language features, generics, streams, exceptions, and concurrency.
  • 1Z0-829 FAQ — Java SE 17 Developer
    Frequently asked questions for Java SE 17 Developer (1Z0-829): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-830 Certification Guide
  Study hub for Oracle 1Z0-830 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-830 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for Java SE 21 Developer Professional (1Z0-830): recommended hours, weekly schedules, and practice integration.
  • 1Z0-830 Cheatsheet — Java SE 21 (Generics, Streams, Exceptions, Concurrency)
    Last-mile 1Z0-830 review: high-yield Java 21 rules and code patterns for generics, collections, streams, exceptions, and concurrency fundamentals.
  • 1Z0-830 FAQ — Java SE 21 Developer Professional
    Frequently asked questions for Java SE 21 Developer Professional (1Z0-830): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-908 Certification Guide
  Study hub for Oracle 1Z0-908 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-908 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for MySQL 8.0 Database Administrator (1Z0-908): recommended hours, weekly schedules, and practice integration.
  • 1Z0-908 Cheatsheet — MySQL 8.0 DBA (Backups, Replication, Security, Performance)
    High-yield 1Z0-908 cheat sheet for MySQL 8.0 DBAs: secure configuration, users/roles, backup/recovery, replication/HA, and performance troubleshooting commands.
  • 1Z0-908 FAQ — MySQL 8.0 Database Administrator
    Frequently asked questions for MySQL 8.0 Database Administrator (1Z0-908): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-909 Certification Guide
  Study hub for Oracle 1Z0-909 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-909 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for MySQL 8.0 Database Developer (1Z0-909): recommended hours, weekly schedules, and practice integration.
  • 1Z0-909 Cheatsheet — MySQL 8.0 Developer (SQL, DDL, Indexes, Stored Programs)
    High-yield 1Z0-909 cheat sheet for MySQL 8.0 developers: SQL patterns, schema rules, indexing and EXPLAIN tips, transactions, and stored program fundamentals.
  • 1Z0-909 FAQ — MySQL 8.0 Database Developer
    Frequently asked questions for MySQL 8.0 Database Developer (1Z0-909): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-931-25 Certification Guide
  Study hub for Oracle 1Z0-931-25 with a study plan, cheat sheet, FAQ, and official resources.
  • Oracle 1Z0-931-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for Oracle AI Autonomous Database 2025 Professional (1Z0-931-25): recommended hours, weekly schedules, and practice integration.
  • 1Z0-931-25 Cheatsheet — Autonomous Database (Security, Performance, Backup/Recovery)
    Last-mile 1Z0-931-25 review: Autonomous Database provisioning pickers, security baseline, performance/scaling signals, backup and recovery rules, and operations checklists.
  • 1Z0-931-25 FAQ — Oracle AI Autonomous Database 2025 Professional
    Frequently asked questions for Oracle AI Autonomous Database 2025 Professional (1Z0-931-25): prerequisites, difficulty, what to focus on, and study strategy.
• Oracle 1Z0-997-25 Certification Guide
  Study hub for Oracle 1Z0-997-25 with a study plan, cheat sheet, FAQ, and official resources.
  • OCI 1Z0-997-25 Study Plan (30 / 60 / 90 Days)
    30/60/90-day study plan for OCI 2025 Architect Professional (1Z0-997-25): recommended hours, weekly schedules, and how to integrate practice.
  • 1Z0-997-25 Cheatsheet — OCI Architect Professional (HA/DR, Security, Scale)
    Last-mile 1Z0-997-25 review: multi-region HA/DR patterns, advanced networking, security architecture, and operational readiness decision rules.
  • 1Z0-997-25 FAQ — OCI Architect Professional
    Frequently asked questions for OCI 2025 Architect Professional (1Z0-997-25): prerequisites, difficulty, what to focus on, and exam strategy.