Oracle Database SQL (1Z0-071)

Exam code 1Z0-071 · Updated Aug 2026

Practice questions for the Oracle Database SQL Certified Associate (1Z0-071) exam. Covers relational concepts, SELECT, restricting and sorting, single-row and group functions, conversion and conditional expressions, joins, subqueries, set operators, DML and transactions, DDL and constraints, and schema objects. Every executable question runs against a real Oracle database before it ships.

Topics covered · 12

Reporting Aggregated Data with Group FunctionsRestricting and Sorting DataSingle-Row FunctionsConversion Functions and Conditional ExpressionsUsing DDL to Manage Tables and ConstraintsUsing Subqueries to Solve QueriesRetrieving Data with SELECTDisplaying Data from Multiple Tables with JoinsManipulating Data (DML) and Transaction ControlManaging Schema Objects and AccessRelational Database ConceptsUsing Set Operators
TestHoop Originals

What's included

Full mock exams
3 exams
Topic drills
26 drills
Total questions
410 across all mocks

Full mock exams

Full Practice Exam 1
120 min · 63 questions
covers: Restricting and Sorting Data, Retrieving Data with SELECT, Displaying Data from Multiple Tables with Joins +9 more
Not started
Full Practice Exam 2
120 min · 63 questions
covers: Restricting and Sorting Data, Retrieving Data with SELECT, Displaying Data from Multiple Tables with Joins +9 more
Not started
Full Practice Exam 3
120 min · 63 questions
covers: Restricting and Sorting Data, Retrieving Data with SELECT, Displaying Data from Multiple Tables with Joins +9 more
Not started

Topic drills

Aggregate Functions
27 min · 12 questions
covers: Reporting Aggregated Data with Group Functions
Not started
Column & Table Aliases
12 min · 6 questions
covers: Restricting and Sorting Data
Not started
Character Functions
27 min · 12 questions
covers: Single-Row Functions
Not started
Conditional Expressions
27 min · 12 questions
covers: Conversion Functions and Conditional Expressions
Not started
Constraints
15 min · 6 questions
covers: Using DDL to Manage Tables and Constraints
Not started
Conversion Functions
27 min · 12 questions
covers: Conversion Functions and Conditional Expressions
Not started
Correlated Subqueries
30 min · 12 questions
covers: Using Subqueries to Solve Queries
Not started
CREATE / ALTER TABLE
12 min · 6 questions
covers: Using DDL to Manage Tables and Constraints
Not started
DISTINCT
12 min · 6 questions
covers: Retrieving Data with SELECT
Not started
GROUP BY / HAVING
15 min · 6 questions
covers: Reporting Aggregated Data with Group Functions
Not started
Inner Joins
22 min · 10 questions
covers: Displaying Data from Multiple Tables with Joins
Not started
INSERT / UPDATE / DELETE
27 min · 12 questions
covers: Manipulating Data (DML) and Transaction Control
Not started
NULL-Handling Functions
27 min · 12 questions
covers: Conversion Functions and Conditional Expressions
Not started
Number & Date Functions
27 min · 12 questions
covers: Single-Row Functions
Not started
ORDER BY
6 min · 4 questions
covers: Restricting and Sorting Data
Not started
Outer Joins
15 min · 6 questions
covers: Displaying Data from Multiple Tables with Joins
Not started
Privileges & Data Dictionary
12 min · 6 questions
covers: Managing Schema Objects and Access
Not started
Relational Model
9 min · 6 questions
covers: Relational Database Concepts
Not started
SELECT & Projection
9 min · 6 questions
covers: Retrieving Data with SELECT
Not started
Single- & Multi-Row Subqueries
30 min · 12 questions
covers: Using Subqueries to Solve Queries
Not started
SQL Statement Categories
9 min · 6 questions
covers: Relational Database Concepts
Not started
Transaction Control
12 min · 6 questions
covers: Manipulating Data (DML) and Transaction Control
Not started
TRUNCATE vs DELETE
12 min · 6 questions
covers: Using DDL to Manage Tables and Constraints
Not started
UNION / INTERSECT / MINUS
12 min · 6 questions
covers: Using Set Operators
Not started
Views, Sequences & Indexes
12 min · 6 questions
covers: Managing Schema Objects and Access
Not started
WHERE Clause
30 min · 15 questions
covers: Restricting and Sorting Data
Not started

Ratings

Sign in to rate this pack.

About Oracle Database SQL (1Z0-071)

Oracle Database SQL (1Z0-071) (1Z0-071) is a practice-exam pack for the Oracle Database certification track. It contains 29 timed mock exams — 410 practice questions, totalling 13 hours 55 minutes of exam time — each with a worked explanation, not just an answer key. Topics covered include Reporting Aggregated Data with Group Functions, Restricting and Sorting Data, Single-Row Functions, Conversion Functions and Conditional Expressions, Using DDL to Manage Tables and Constraints, Using Subqueries to Solve Queries, Retrieving Data with SELECT, Displaying Data from Multiple Tables with Joins, Manipulating Data (DML) and Transaction Control, Managing Schema Objects and Access, Relational Database Concepts and Using Set Operators. Questions target the current Database exam objectives at an intermediate level. Practice questions for the Oracle Database SQL Certified Associate (1Z0-071) exam. Covers relational concepts, SELECT, restricting and sorting, single-row and group functions, conversion and conditional expressions, joins, subqueries, set operators, DML and transactions, DDL and constraints, and schema objects. Every executable question runs against a real Oracle database before it ships.

Topics covered

  • Reporting Aggregated Data with Group Functions
  • Restricting and Sorting Data
  • Single-Row Functions
  • Conversion Functions and Conditional Expressions
  • Using DDL to Manage Tables and Constraints
  • Using Subqueries to Solve Queries
  • Retrieving Data with SELECT
  • Displaying Data from Multiple Tables with Joins
  • Manipulating Data (DML) and Transaction Control
  • Managing Schema Objects and Access
  • Relational Database Concepts
  • Using Set Operators

Practice by topic

Each topic has its own page of worked questions — the prompt, every option, why each is right or wrong, and the explanation.

At a glance

Exam code
1Z0-071
Vendor
Oracle
Track
Database
Difficulty
Intermediate
Practice questions
410
Mock exams
29
Total exam time
13 hours 55 minutes
Topics covered
Reporting Aggregated Data with Group Functions, Restricting and Sorting Data, Single-Row Functions, Conversion Functions and Conditional Expressions, Using DDL to Manage Tables and Constraints, Using Subqueries to Solve Queries, Retrieving Data with SELECT, Displaying Data from Multiple Tables with Joins, Manipulating Data (DML) and Transaction Control, Managing Schema Objects and Access, Relational Database Concepts, Using Set Operators
Author
TestHoop Originals

Frequently asked questions

How many practice questions does Oracle Database SQL (1Z0-071) include?

Oracle Database SQL (1Z0-071) includes 410 practice questions across 29 timed mock exams, each with a detailed explanation.

How long are the Oracle Database mock exams?

This pack contains 13 hours 55 minutes of timed practice across 29 mock exams, mirroring real exam conditions.

What topics does Oracle Database SQL (1Z0-071) cover?

Oracle Database SQL (1Z0-071) covers Reporting Aggregated Data with Group Functions, Restricting and Sorting Data, Single-Row Functions, Conversion Functions and Conditional Expressions, Using DDL to Manage Tables and Constraints, Using Subqueries to Solve Queries, Retrieving Data with SELECT, Displaying Data from Multiple Tables with Joins, Manipulating Data (DML) and Transaction Control, Managing Schema Objects and Access, Relational Database Concepts and Using Set Operators — the areas the Oracle Database exam objectives examine.

How hard is the 1Z0-071 exam?

Oracle Database SQL (1Z0-071) is pitched at an intermediate level and tracks the current Oracle Database objectives.

Can I try Oracle Database SQL (1Z0-071) for free?

You can practise questions from this pack without an account. Timed mock exams and saved progress need a free sign-in.