Browse Exams — Mock Exams & Practice Tests

1Z0-071 Overview — Oracle Database SQL

What 1Z0-071 covers: SELECT basics, filtering and NULL semantics, joins, grouping/aggregation, subqueries, set operators, DDL/DML, and analytic functions awareness.

On this page

Oracle Database SQL is a classic, evergreen certification. It validates that you can write correct SQL and interpret query results precisely.

What you should be able to do

  • Write and interpret SELECT queries with correct filtering and ordering.
  • Handle NULL values correctly in expressions, predicates, and joins.
  • Use joins safely (inner/outer) without changing semantics accidentally.
  • Aggregate correctly with GROUP BY, HAVING, and conditional aggregation.
  • Use subqueries and set operators to express intent.
  • Understand DDL/DML basics: tables, constraints, inserts/updates/deletes, and transactions.

Efficient prep strategy

  1. Use the Syllabus as your checklist.
  2. Drill edge cases: NULLs, LEFT JOIN filters, duplicate amplification, grouping granularity.
  3. Use the Cheatsheet for last‑mile rules and patterns.
Study Plan