Oracle 1Z0-071 study guide
Oracle 1Z0-071 · Work through your exam, one topic at a time.
The Oracle Database SQL exam, exam code 1Z0-071, is the certification test behind the Oracle Database SQL Certified Associate credential. It is aimed at developers, database administrators, data analysts and students who want to demonstrate that they can write and reason about SQL against an Oracle Database rather than only read about it. The Oracle 1Z0-071 study guide has 14 sections and about 4,998 words.
01Relational Database Fundamentals and SQL SELECT Basics
Domain 1 tests relational vocabulary and the logical order of a SELECT statement. You must distinguish tables, rows, columns, primary keys, foreign keys, and NULL, and know how Oracle evaluates a query even when the SELECT list is written first.
350 words, about 2 min02Restricting and Sorting Data
Domain 2 tests row filtering with WHERE and deterministic ordering with ORDER BY. The exam expects precise predicate behavior, especially with NULL, wildcards, ranges, and multiple sort keys.
352 words, about 2 min03Single-Row Functions
Domain 3 tests functions that return one result per input row. You need to choose the right character, numeric, date, and general function and predict its return value, including behavior with NULL.
334 words, about 2 min04Conversion Functions and Conditional Expressions
Domain 4 tests explicit and implicit data conversion plus conditional logic with CASE, DECODE, NVL, NULLIF, and COALESCE. The exam rewards knowing when Oracle converts automatically and why relying on that is risky.
391 words, about 2 min05Group Functions and Aggregated Data
Domain 5 tests aggregation across sets of rows: SUM, AVG, MIN, MAX, COUNT, GROUP BY, and HAVING. You must distinguish row-level filtering from group-level filtering and understand NULL treatment.
353 words, about 2 min06Joins and Subqueries
Domain 6 tests combining rows from multiple tables and nesting queries to answer multi-step questions. You must know join types, join conditions, subquery cardinality, and correlated references.
357 words, about 2 min07Set Operators
Domain 7 tests combining result sets vertically with UNION, UNION ALL, INTERSECT, and MINUS. The exam focuses on column compatibility, duplicate handling, and where ORDER BY is allowed.
373 words, about 2 min08Data Manipulation Language (DML)
Domain 8 tests changing table data with INSERT, UPDATE, DELETE, and MERGE, plus transaction control. You must understand row counts, constraints, and what can be rolled back.
337 words, about 2 min09Data Definition Language (DDL) and Schema Objects
Domain 9 tests creating and changing schema objects with DDL: tables, constraints, and related structures. The exam expects you to know data types, constraint behavior, and which operations commit implicitly.
375 words, about 2 min10Views, Sequences, Synonyms and Indexes
Domain 10 tests schema objects that simplify access, generate numbers, and improve performance. You must know view restrictions, sequence behavior, synonym resolution, and index trade-offs.
373 words, about 2 min11Access Control and User Privileges
Domain 11 tests Oracle privilege management: users, system privileges, object privileges, roles, and grant options. The exam expects least-privilege reasoning and precise GRANT/REVOKE syntax.
337 words, about 2 min12Date and Time Handling
Domain 12 tests Oracle datetime data types, arithmetic, conversion, and time zone behavior. You must know the difference between DATE and TIMESTAMP and how session settings affect results.
365 words, about 2 min13Regular Expressions
Domain 13 tests Oracle regular expression functions: REGEXP LIKE, REGEXP SUBSTR, REGEXP INSTR, REGEXP REPLACE, and REGEXP COUNT. You must read patterns, use match parameters, and predict what is returned or replaced.
318 words, about 2 min14Oracle-Specific SQL Features
Domain 14 tests Oracle extensions and idioms that appear throughout the exam: DUAL, ROWNUM, ROWID, NVL, DECODE, MERGE, and row-limiting behavior. You must know when Oracle-specific logic differs from standard SQL expectations.
383 words, about 2 min