1Z0-149 study materials

1Z0-149 study guide

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

The Oracle Database SQL 1Z0-149 exam is the certification test behind the Oracle Database SQL Certified Associate credential. It validates that you can write and reason about SQL against an Oracle Database using SQL Plus or SQL Developer: querying one and many tables, filtering and sorting, single-row and conversion functions, conditional logic, aggregate reporting, subqueries, set operators, DML, and the objects around them such as indexes, sequences, synonyms, views, temporary tables, and data dictionary views. The 1Z0-149 study guide has 12 sections and about 4,008 words.

Retrieving Data Using the SQL SELECT Statement

This domain covers the basic Oracle SELECT statement: choosing columns, filtering rows, naming output columns, using expressions, and eliminating duplicates. The exam expects precise syntax and an understanding of how NULL behaves in expressions.

333 words, about 2 min 02

Restricting and Sorting Data

Restricting and sorting tests WHERE predicates, comparison and logical operators, pattern matching, NULL tests, and ORDER BY behavior. WHERE filters individual rows before grouping.

344 words, about 2 min 03

Using Single-Row Functions to Customize Output

Single-row functions return one result per input row. The exam tests character, numeric, date, and general functions, including nesting and NULL behavior.

342 words, about 2 min 04

Using Conversion Functions and Conditional Expressions

This domain covers explicit and implicit data conversion, format models, and conditional expressions used to transform output. TO CHAR(number, 'fmt') and TO CHAR(date, 'fmt') format values.

346 words, about 2 min 05

Reporting Aggregated Data Using Group Functions

Group functions summarize sets of rows. The exam tests GROUP BY , HAVING , aggregate NULL handling, and grouping extensions.

316 words, about 2 min 06

Displaying Data from Multiple Tables

This domain tests joining rows from multiple tables using ANSI join syntax and Oracle's legacy outer-join operator. An inner join returns only matching rows.

317 words, about 2 min 07

Using Subqueries to Solve Queries

Subqueries solve queries in stages. The exam tests single-row and multi-row subqueries, correlated subqueries, EXISTS , and inline views.

346 words, about 2 min 08

Using Set Operators

Set operators combine result sets vertically. The exam tests UNION , UNION ALL , INTERSECT , MINUS , and the rules for compatible queries.

325 words, about 2 min 09

Managing Tables Using DML Statements

DML changes table data. The exam tests INSERT , UPDATE , DELETE , MERGE , transaction control, and the difference between DML and DDL.

331 words, about 2 min 10

Managing Indexes, Synonyms, and Sequences

This domain tests index, synonym, and sequence objects: creating them, using them, and understanding their behavior. CREATE INDEX builds an index.

324 words, about 2 min 11

Managing Views and Temporary Tables

Views and temporary tables provide controlled or session-specific access to data. The exam tests view creation, DML through views, and temporary table scope.

339 words, about 2 min 12

Managing Objects with Data Dictionary Views

Data dictionary views describe database objects. The exam tests USER , ALL , and DBA views and the specific views used to inspect tables, columns, constraints, indexes, views, sequences, and synonyms.

345 words, about 2 min