1z0-071
Oracle Database SQL practice test
505 Oracle 1z0-071 practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.
Full access
$99
- All 505 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Questions
- 505
- Free samples
- 20
- Versions
- 1
- Updated
- Jan 2026
Exam simulator
Practice 1z0-071 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
1z0-071, by the numbers.
Official specifications published by Oracle.
- Duration
- 120 min
- Questions
- 63
- Passing score
- 63%
- Exam fee
- $245

Exam guide
Everything about 1z0-071.
1z0-071 · Oracle · v1.0
What is 1z0-071?
1z0-071 tests whether you can write SQL to query and change data in an Oracle database. A pass makes you an Oracle Database SQL Certified Associate. Developers, data analysts and future DBAs take it as an entry point to Oracle certification. Joins are a big topic: a join combines rows from two or more tables through a shared column. For example, you may write a query that lists each customer with the total value of their orders. The practice questions here focus on SELECT queries, functions, joins, subqueries and table changes.
What you'll practise
- Write SELECT statements that filter, sort and format results.
- Use single-row, conversion and group functions to shape data.
- Join tables and write subqueries and set operations.
- Insert, update and delete rows and control transactions.
- Create tables, constraints, views, indexes and sequences with DDL.
- Grant privileges and query the data dictionary.
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: a basic understanding of relational database concepts.
- Recommended: some experience working with databases and command-line tools.
Who it's for
- Database and SQL developers who work with Oracle.
- Data analysts and business intelligence staff who write queries.
- Future DBAs planning Oracle Database Administration I and II.
Exam details
Published by Oracle, plus what is in our question bank.
What does 1z0-071 cover?
16 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.
How do I earn this certification?
Passing 1z0-071 earns the Oracle Database SQL Certified Associate in the Database track.
How to study for this exam?
Use the 1z0-071 practice test alongside the official material below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
- Last content update
- 2025
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator