Oracle 1Z0-182 study guide

Oracle 1Z0-182 · Work through your exam, one topic at a time.

The Oracle Database SQL 1Z0-182 exam is the assessment behind the Oracle Database SQL Certified Associate credential, one of the entry points into Oracle's database certification track. It is aimed at developers, report writers, data analysts, and junior DBAs who need to write and read SQL against an Oracle database rather than administer it. The Oracle 1Z0-182 study guide has 9 sections and about 2,752 words.

Relational Database Concepts and SQL Fundamentals

This domain tests the vocabulary and rules behind Oracle’s relational model and the categories of SQL used throughout the exam. Questions focus on keys, NULL semantics, schema ownership, data types, and statement types rather than on one query syntax.

349 words, about 2 min 02

Retrieving Data with SELECT: Filtering, Sorting, and Row Limiting

This domain tests single-table retrieval: choosing columns, filtering rows, sorting, removing duplicates, and limiting rows. Oracle evaluates FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, then row limiting.

300 words, about 2 min 03

Single-Row and Group Functions, and Grouping Data

This domain tests scalar functions that act on one row and aggregate functions that summarize groups, plus the rules for GROUP BY and HAVING. Single-row functions return one value per row: NVL, NVL2, COALESCE, NULLIF, CASE, DECODE, TO CHAR, TO DATE, ROUND, TRUNC, SUBSTR, INSTR, UPPER, LOWER, and SYSDATE/CURRENT DATE.

271 words, about 1 min 04

Joins and Subqueries

This domain tests combining rows from multiple tables and using queries inside queries. Know inner, outer, cross, self, and natural joins, plus single-row, multi-row, correlated, and scalar subqueries.

299 words, about 1 min 05

Data Manipulation Language: INSERT, UPDATE, DELETE, and MERGE

This domain tests INSERT, UPDATE, DELETE, and MERGE, including the effect of constraints and transactions. DML changes data and remains uncommitted until COMMIT or an implicit commit.

289 words, about 1 min 06

Data Definition Language: Tables, Constraints, and Views

This domain tests creating and altering tables, enforcing constraints, and defining views. DDL statements change object definitions and commit automatically.

309 words, about 2 min 07

Other Schema Objects: Sequences, Synonyms, and Indexes

This domain tests three supporting objects: sequences that generate numbers, synonyms that provide alternative names, and indexes that speed access. CREATE SEQUENCE defines START WITH, INCREMENT BY, MINVALUE, MAXVALUE, CYCLE/NOCYCLE, and CACHE/NOCACHE.

303 words, about 2 min 08

Managing Schema Objects and Users with Oracle Tools

This domain tests using Oracle tools, especially SQL Plus and SQL Developer, to create and inspect schema objects and user accounts. Know SQL Plus commands versus SQL statements and the data dictionary views that report object and user information.

327 words, about 2 min 09

Controlling User Access and Transactions

This domain tests privileges, roles, and transaction control. Know the difference between system and object privileges, how grant options propagate, and which operations commit implicitly.

305 words, about 2 min