Stepwise-Lab

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.

  1. 1Relational Database Concepts
  2. 2Retrieving, Restricting and Sorting Data using SQL
  3. 3Using Functions
  4. 4Displaying Data from Multiple Tables
  5. 5Using Subqueries to Solve Queries
  6. 6Using SET Operators
  7. 7Managing Tables using DML Statements
  8. 8Managing Indexes, Synonyms and Sequences
  9. 9Use DDL to Manage Tables and Their Relationships
  10. 10Controlling User Access
  11. 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.

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.

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.