Oracle 1Z0-084 study guide

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

The Oracle Database SQL Certified Associate credential is an entry-level certification that verifies practical SQL skills against an Oracle Database. It suits developers, data analysts, report writers, application support staff, and students who need to query and change data rather than administer the server. The Oracle 1Z0-084 study guide has 10 sections and about 3,556 words.

Retrieving and Restricting Data with SELECT

This domain tests whether you can project the columns you need, filter rows with predicates, and control row order. Oracle evaluates a query logically as FROM, WHERE, SELECT, then ORDER BY, which explains what each clause can reference.

326 words, about 2 min 02

Using Single-Row and Conversion Functions

This domain tests functions that return one result for each input row. They can appear in SELECT, WHERE, and ORDER BY, and can be nested.

336 words, about 2 min 03

Reporting Aggregated Data Using Group Functions

This domain tests summarizing rows with group functions, forming groups, and filtering groups. The exam checks whether you know when WHERE applies and when HAVING applies, how nulls affect aggregates, and how subtotal extensions change result sets.

330 words, about 2 min 04

Displaying Data from Multiple Tables (Joins)

This domain tests combining rows from related tables. You must choose the correct join type, place filter conditions correctly, and avoid accidental row multiplication.

360 words, about 2 min 05

Using Subqueries and Set Operators

This domain tests nested queries and combining result sets. You need to distinguish single-row from multi-row subqueries, understand correlated execution, and apply set operators with compatible column lists.

362 words, about 2 min 06

Manipulating Data with DML (INSERT, UPDATE, DELETE, MERGE)

This domain tests changing table data and managing the transaction. You must know single-row and multi-row INSERT forms, UPDATE and DELETE behavior, MERGE semantics, defaults, and commit or rollback effects.

356 words, about 2 min 07

Using DDL to Create and Manage Tables and Constraints

This domain tests creating and altering tables and enforcing rules with constraints. You need to choose appropriate data types and understand constraint states, foreign keys, and DDL side effects.

389 words, about 2 min 08

Creating and Managing Other Schema Objects (Views, Sequences, Indexes, Synonyms)

This domain tests supporting schema objects. You must know when views are updatable, how sequences generate values, how indexes affect access, and how synonyms provide names for objects.

361 words, about 2 min 09

Managing Objects with Data Dictionary Views

This domain tests finding metadata through Oracle's data dictionary. You must choose the correct view prefix, join related dictionary views, and interpret constraint and object information.

368 words, about 2 min 10

Controlling User Access and Privileges

This domain tests authentication-related object creation and authorization. You need to distinguish system privileges from object privileges, use roles, and apply grant options correctly.

368 words, about 2 min