Exam guide
Exam 1Z0-171: Oracle AI Database 26ai SQL Associate
Everything about exam 1Z0-171: what it checks, how it is run, what it covers section by section, and how to prepare for it on a real Oracle AI Database 26ai.
60
Questions
120 minutes
Time
65%
Pass mark
Oracle AI Database 26ai
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-171 checks that you can write and read SQL the way Oracle AI Database 26ai 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 11 sections. Each question on the exam belongs to one of them.
- 1Relational Database Concepts
- 2Retrieving, Restricting and Sorting Data using SQL
- 3Using Functions
- 4Displaying Data from Multiple Tables
- 5Using Subqueries to Solve Queries
- 6Using SET Operators
- 7Managing Tables using DML Statements
- 8Managing Indexes, Synonyms and Sequences
- 9Use DDL to Manage Tables and Their Relationships
- 10Controlling User Access
- 11Managing Objects with Data Dictionary Views and 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 SELECT61 questions
- Restricting and sorting40 questions
- Single-row functions36 questions
- Conversion and conditional45 questions
- Aggregation50 questions
- Joins39 questions
- Subqueries32 questions
- Set operators31 questions
- DML and transactions45 questions
- Tables and constraints56 questions
- Views, sequences, indexes47 questions
- Data dictionary30 questions
- User access control51 questions
- Time zones and intervals44 questions
How the app prepares you for 1Z0-171
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 exercises211 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 60 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, 390 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.