Exam guide
Exam 1Z0-071: Oracle Database SQL
Everything about exam 1Z0-071: what it checks, how it is run, what it covers section by section, and how to prepare for it on a real Oracle Database 19c.
63
Questions
120 minutes
Time
63%
Pass mark
Oracle Database 19c
Database version
This is the format our mock exams follow. Check the current format and price with the exam provider before you book.
About the exam
Exam 1Z0-071 checks that you can write and read SQL the way Oracle Database 19c runs it: queries over several tables, single-row and group functions, subqueries and set operators, changing data in transactions, and creating and managing tables, constraints, views, indexes, sequences and user access.
The questions are multiple choice: some have one right answer, others ask you to pick two or three. Many show a statement and ask what it returns, which error it raises, or which statements give the same result, so knowing the rules is not enough: you need to have run the SQL yourself.
What the exam covers
The exam objectives, in 16 sections. Each question on the exam belongs to one of them.
- 1Relational Database concepts
- 2Retrieving Data using the SQL SELECT Statement
- 3Restricting and Sorting Data
- 4Using Single-Row Functions to Customize Output
- 5Using Conversion Functions and Conditional Expressions
- 6Reporting Aggregated Data Using Group Functions
- 7Displaying Data from Multiple Tables
- 8Using Subqueries to Solve Queries
- 9Using SET Operators
- 10Managing Tables using DML statements
- 11Managing Indexes Synonyms and Sequences
- 12Use DDL to manage tables and their relationships
- 13Managing Views
- 14Controlling User Access
- 15Managing Objects with Data Dictionary Views
- 16Managing Data in Different Time Zones
Practise by topic
The same material in 14 topics, each with its own page: what it covers and practice questions with answers.
- Basic SELECT53 questions
- Restricting and sorting35 questions
- Single-row functions33 questions
- Conversion and conditional42 questions
- Aggregation46 questions
- Joins38 questions
- Subqueries32 questions
- Set operators29 questions
- DML and transactions38 questions
- Tables and constraints45 questions
- Views, sequences, indexes44 questions
- Data dictionary29 questions
- User access control47 questions
- Time zones and intervals43 questions
How the app prepares you for 1Z0-071
Each part opens in the app. Start without an account; the progress you make stays with you when you create one.

Your dayA session every day made from your weak topics: questions, flashcards and one exercise, with your level, streak and weekly goal.
SQL exercises190 exercises checked on the database: your rows beside the reference ones, a hint when you are stuck and an AI explanation of the mistake.
SQL labRun any query on your own schema, step through it clause by clause, then follow single rows through joins and groups.
DDL DesignerDraw tables and the relationships between them and get the CREATE TABLE script, or write the script and see the diagram.
Mock examsFull mock exams of 63 questions in 120 minutes, or shorter ones on the topics you choose, with your scores from one to the next.
Book and trophiesA book that follows the exam objectives, 340 flashcards that come back just before you forget, and trophies for real milestones.
How to prepare
Practise a little every day, write the SQL yourself instead of only reading it, and take full mock exams on questions you have not seen. Book the exam once your estimated score is above the pass mark in several of them.