Lesson 3	Areas of Oracle knowledge on the test
Objective	Map modern Oracle certification paths (19c/23c/23ai) to the core knowledge areas—especially networking and connectivity.

Areas of Oracle Knowledge on Today’s Oracle Exams

Oracle’s certification program evolves with each release. Instead of memorizing old test lengths or deprecated tracks, align your prep to the current role-based paths and the skills exam blueprints measure: multitenant architecture, security, networking, backup & recovery, performance, and on newer tracks—23ai capabilities.

Certification landscape (at a glance)

Oracle Database SQL Associate foundation in SQL and data modeling; a common on-ramp for DBA and developer paths.
Database Administration (19c/23c/23ai) — Associate & Professional levels that cover install/upgrade, CDB/PDB management, backup & recovery, performance, security, and networking.
Cloud DBA paths — administering Oracle Database on OCI (DB Systems, Autonomous, HA/backup in cloud).
Focused depth — 19c specialties such as Data Guard, RAC/ASM/Grid, and Performance Tuning remain valuable for on-prem and hybrid environments.

What you should know (by domain)

1) Core architecture & administration

Multitenant: CDB/PDB lifecycle (create, clone, plug/unplug), local vs. common users/roles, resource plans, PDB lockdown profiles.
Upgrade & patching: DBUA/AutoUpgrade basics, Release Updates (RU), compatibility settings, fallback planning.
Storage & space: tablespaces/segments/extents, ASM basics, compression/partitioning (conceptual), undo/redo.

2) Backup, recovery, and availability

RMAN: full/incremental backups, validate, block media recovery, recovery windows/retention, catalog vs. control file.
HA patterns: concepts of Data Guard (primary/standby roles, switchover/failover, lag) and RAC (instance vs. database, services, SCAN).

3) Performance management

Workload visibility: AWR/ASH/ADDM, wait events, execution plans, stats gathering.
Indexing & SQL: common access paths, optimizer basics, plan stability, SQL Profiles/Baselines (conceptual).

4) Security & compliance

AuthN/AuthZ: users/roles/profiles, password/verifier changes, unified auditing (conceptual), privileges vs. roles.
Data protection: TDE (at rest), network encryption and integrity (on the wire), least privilege and separation of duties.

5) Networking & connectivity (this module’s focus)

Oracle Net Services: listener basics, dynamic service registration, static service entries (when needed), service names vs. SIDs.
Naming & connection syntax: Easy Connect and Easy Connect Plus (service, wallet, TLS/mTLS, timeouts, load balancing), tnsnames.ora structure, parameter hygiene.
Enterprise patterns: Connection Manager (CMAN) for access control, DMZ traversal, and fan-out; SCAN for RAC; DRCP for pooled server sessions.
Resilience & SRE basics: connect time vs. run time failover, SQLNET.INBOUND_CONNECT_TIMEOUT / SQLNET.OUTBOUND_CONNECT_TIMEOUT, client retries, application-driven health checks.

6) Cloud & automation

Provisioning: DBCA (on-prem), DB Systems/Autonomous (cloud); parameter baselines, secure defaults.
Automation & jobs: scheduler concepts, Fleet Patching & Provisioning (overview), observability with Cloud Control/OCI metrics.

What’s new in 23c/23ai (awareness level)

AI-adjacent features: basics of vector search (use cases, indexing and similarity search) and how app tiers connect securely to use them.
Modern SQL & JSON: expect more JSON-centric design patterns and API-friendly schemas; know how connectivity and security policies apply to these workloads.

How to prepare

Anchor to the current blueprint. Start from the official exam page for your target version/role and list each topic in a study tracker.
Lab everything. Build a small CDB with one or two PDBs; practice service registration, TLS/mTLS with wallets, Easy Connect Plus syntax, and CMAN rules.
Operational drills. Run RMAN validate, simulate a lost datafile, do a switchover in a sandbox, trace a slow connection (listener + client).