SQLMentor // cert practice
← All certifications
// 1Z0-071 practice

Oracle Database SQL Certified Associate (1Z0-071)

Take a full-length, timed practice exam modelled on the Oracle Database SQL Certified Associate (1Z0-071). Each set has 63 MCQs and a 2-hour window. Pass mark: 63%.

63questions per exam
120minute timer (auto-submit)
63%passing score
3independent question sets

About this certification

The Oracle Database SQL Certified Associate (1Z0-071) is Oracle's foundational SQL certification, recognised globally as proof of competence with Oracle SQL. It validates that you can write, read, and reason about queries — including joins, subqueries, set operators, DML, DDL, and constraint management.

Register on Oracle University ↗

Exam format

  • Questions: 63 multiple choice
  • Duration: 120 min (≈ 1 min 54 s / question)
  • Pass mark: 63%
  • Delivery: Pearson VUE or Oracle Online Proctoring
  • Cost: US$245 (varies by region)
  • Re-take wait: 14 days minimum if you fail
Topics covered & study plan

Topics covered

Relational database concepts, SELECT, WHERE / ORDER BY, single-row functions, conversion & conditional expressions, group functions, multi-table joins, subqueries, set operators, DDL (CREATE/ALTER/DROP), DML (INSERT/UPDATE/DELETE/MERGE), constraints, views, sequences, synonyms, and data dictionary views.

Recommended study plan

  1. Work through the Oracle SQL tutorial in order.
  2. Practise queries in the in-browser SQL editor on the HR schema.
  3. Take Practice Set 1 under timing — accept the score without reviewing mid-exam.
  4. Go through every wrong answer's explanation; re-read the related topic.
  5. Repeat Sets 2 and 3 at least 24 hours apart.
  6. You're ready when scoring ≥ 73% consistently (a 10% cushion above the cut score).

Pick a set to begin

Loading exam sets…
How the exam works
  • The 2-hour timer starts the moment you click Start exam.
  • Use the question grid to jump between questions; flag any you want to revisit.
  • Click Submit exam at any time to finish early; if the timer reaches zero, the exam auto-submits.
  • After submission you'll see your score, pass/fail status and per-question feedback with explanations.
  • Your progress is kept in the browser only — refreshing during an exam will reset it.

Frequently asked questions — 1Z0-071

How many questions are on the 1Z0-071 exam?
The 1Z0-071 exam contains 63 multiple-choice questions to be answered in 120 minutes. SQLMentor's free practice sets mirror that format so the timing feels familiar on exam day.
What is the passing score for 1Z0-071?
The official passing score for the 1Z0-071 exam is 63%. Each SQLMentor practice set is scored against that same threshold and shows a clear PASS or FAIL on the results screen.
How long should I prepare for the 1Z0-071 exam?
Most candidates prepare for 4 to 8 weeks with consistent daily study. We recommend reading through the SQLMentor tutorials first, then running timed practice sets in the final two weeks until you score above 63% consistently.
Is the SQLMentor 1Z0-071 practice exam free?
Yes. Every 1Z0-071 practice set on SQLMentor is 100% free with no sign-up, no email gate and no paywall. Your progress is saved locally in your browser.
What topics does 1Z0-071 cover?
SELECT statements, SQL functions, joins, subqueries, set operators, DDL, DML, transactions, NULL handling, constraints, views, indexes, sequences and the Oracle data dictionary. The SQLMentor sets are organised so each set samples across all of these areas to give you a realistic mix on every attempt.