ExamDumpster

1Z0-171

Database 23ai SQL Certified Associate practice test

135 Oracle 1Z0-171 practice questions with explanations, in study, timed and flashcard modes. 12 sample questions are free.

Full access

$99

  • All 135 questions, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Oracle logo
Questions
135
Free samples
12
Versions
1
Updated
Mar 2026

Exam simulator

Practice 1Z0-171 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

1Z0-171, by the numbers.

Official specifications published by Oracle.

Open the full exam guide

Exam guide

Everything about 1Z0-171.

1Z0-171 · Oracle

What does 1Z0-171 cover?

The practice test's questions, grouped by exam topic. Open a topic to see what it covers.

11 topics · 45 subtopics · 135 questions

  • Use CREATE TABLE statements7 questions
  • Explain the TRUNCATE TABLE statement4 questions
  • Apply how to manage constraints8 questions
  • Describe working with tables3 questions
  • Explain managing views3 questions
  • Demonstrate dropping columns and setting column UNUSED2 questions
  • Create and use temporary tables2 questions
  • Describe working with columns and data types2 questions

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 simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

1Z0-171 questions, answered