Oracle Database SQL

What's on the exam

1. Domain 1: Relational concepts and retrieving data

   10 %

   Relational database concepts and ERDs; SELECT with arithmetic expressions, NULL values, the concatenation operator, literals, the alternative quote operator, DISTINCT and column aliases.

   Practice domain 1 →

2. Domain 2: Restricting and sorting data

   10 %

   WHERE conditions, operator precedence, LIKE, IN, BETWEEN and IS NULL; ORDER BY with NULLS FIRST/LAST; the row limiting clause (FETCH FIRST, OFFSET, WITH TIES); substitution variables, DEFINE and VERIFY.

   Practice domain 2 →

3. Domain 3: Single-row functions and conversion

   15 %

   Character, number (ROUND, TRUNC, MOD) and date functions, date arithmetic; TO_CHAR, TO_NUMBER and TO_DATE, implicit and explicit conversion; NVL, NVL2, NULLIF, COALESCE, CASE and DECODE; nesting functions.

   Practice domain 3 →

4. Domain 4: Group functions

   9 %

   COUNT, SUM, AVG, MIN, MAX and NULL handling, DISTINCT in aggregates, GROUP BY, HAVING and nesting group functions.

   Practice domain 4 →

5. Domain 5: Joining tables

   12 %

   Inner joins with USING, ON and NATURAL JOIN, non-equijoins, self-joins, LEFT, RIGHT and FULL OUTER JOIN, the Oracle (+) operator, Cartesian products and CROSS JOIN.

   Practice domain 5 →

6. Domain 6: Subqueries and set operators

   14 %

   Single-row and multiple-row subqueries (IN, ANY, ALL, EXISTS), NOT IN with NULLs, correlated subqueries in UPDATE and DELETE; UNION, UNION ALL, INTERSECT and MINUS, column matching and ORDER BY in set operations.

   Practice domain 6 →

7. Domain 7: DML and transactions

   10 %

   INSERT, UPDATE, DELETE and MERGE, multitable INSERT ALL and INSERT FIRST; COMMIT, ROLLBACK, SAVEPOINT, implicit commits, read consistency and locking.

   Practice domain 7 →

8. Domain 8: DDL: tables, constraints and schema objects

   14 %

   CREATE TABLE and data types, ALTER TABLE, dropping and UNUSED columns, TRUNCATE, temporary and external tables, constraints; views; sequences, synonyms and indexes.

   Practice domain 8 →

9. Domain 9: Access control, data dictionary and time zones

   6 %

   System and object privileges, roles, GRANT, REVOKE and WITH GRANT OPTION; USER_, ALL_ and DBA_ dictionary views; CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP, TIMESTAMP WITH TIME ZONE and INTERVAL types.

   Practice domain 9 →

Domain names and weights come from the official 1Z0-071 exam objectives (checked 2026-10-28). Always check it for the authoritative scope.

Includes 89 performance-style items (put in order, match, read an exhibit) — practice them with the “Order / match” filter.