Oracle Database SQL: queries and operations

Objectives and progression

Initial course with eight lessons and 56 original decisions, including eight fictional APS and technical-management cases. Internal assessment of 32 decisions in 70 minutes. Maps 16 objective groups at initial depth using 26ai technical documentation with explicit compatibility boundaries. Executable Oracle labs and deeper preparation need further development. 1Z0-071: the official page inspected 2026-09-30 states 63 questions, 120 minutes, and a 63% passing score. Its 16 objective groups were inspected; no explicit revision date or domain weights are published. Oracle also lists 1Z0-171 separately, without an inferred replacement relationship.

Audience: Developers, analysts, APS teams, and technical managers needing to interpret SQL and data decisions.

Prerequisites: Basic tables, keys, SELECT queries, and application operations.

435 estimated study minutes

• Define grain and correctly interpret selection, NULL, and ordering.
• Transform values while preserving meaning across missing data, formats, and types.
• Preserve the correct population and avoid relationship-multiplied totals.
• Choose existence, difference, and cardinality with explicit semantics.
• Identify commit boundaries before correcting or replaying a load.
• Distinguish data rules, identifier generation, and access structures.
• Diagnose dependencies and privileges without expanding access by trial.
• Control substitution, temporary data, and structural changes in operational loads.

Modules

1. Model, SELECT, and result population
2. Functions, conversions, and data contracts
3. Joins, grain, and aggregation
4. Subqueries, sets, and top-N
5. DML, transactions, and resumption
6. Integrity, sequences, and indexes
7. Views, access, and the data dictionary
8. Scripts, time, and data lifecycle

Continue learning

Databases

• SQL
• Oracle Database Administration
• Production Support L3
• Middleware

References and version

1Z0-071 public objectives inspected 2026-09-30; revision date not published

• Oracle Database SQL 1Z0-071: current format and public objectives · 2026-09-30
• Oracle certification catalogue · 2026-09-30
• Null semantics and empty strings · 2026-09-30
• Selection ordering and row limits · 2026-09-30
• Join preservation and multiplicity · 2026-09-30
• Grouping and null handling · 2026-09-30
• Explicit date conversion · 2026-09-30
• Membership and nullable anti-joins · 2026-09-30
• Transactions and implicit DDL commits · 2026-09-30
• Integrity constraints · 2026-09-30
• Scalar cardinality · 2026-09-30
• Set operators and types · 2026-09-30
• Deterministic analytic ordering · 2026-09-30
• Sequence allocation · 2026-09-30
• Deterministic merge and source keys · 2026-09-30
• Transaction rollback · 2026-09-30
• Partial rollback · 2026-09-30
• Truncation behavior · 2026-09-30
• Views privileges and check option · 2026-09-30
• Synonyms and authorization · 2026-09-30
• System and object privileges · 2026-09-30
• Null substitution and types · 2026-09-30
• Conditional results · 2026-09-30
• Single-row functions · 2026-09-30
• Oracle types and date arithmetic · 2026-09-30
• Session time zone · 2026-09-30
• Formatting dates as text · 2026-09-30
• Object names and qualification · 2026-09-30
• Numeric rounding · 2026-09-30
• Locale-aware numeric conversion · 2026-09-30
• Indexes and null key entries · 2026-09-30
• ROWNUM and ordering · 2026-09-30
• Temporary and external tables · 2026-09-30
• Column lifecycle · 2026-09-30
• Multitable insert · 2026-09-30
• Read consistency and statement atomicity · 2026-09-30
• Relational tables and keys · 2026-09-30
• Owned table columns · 2026-09-30
• Accessible table columns · 2026-09-30
• SQL Plus scripts and substitution · 2026-09-30
• SQL Plus substitution, DEFINE and VERIFY · 2026-09-30