// certifications

Certification Practice

Q: Which Oracle SQL certification should I take first?

Start with 1Z0-071. It is the foundational Oracle SQL associate exam and a prerequisite mindset for everything else — joins, DDL, DML, subqueries and views. After 1Z0-071, move to 1Z0-082 (DBA I) if you administer databases or 1Z0-149 (PL/SQL Professional) if you write procedural Oracle code.

Choose a certification track to start practicing. Each track includes timed mock exams, full question banks, and per-question explanations.

Available now

ORACLE 1Z0-071

Oracle Database SQL Certified Associate

Foundational Oracle SQL certification covering joins, DDL, DML, subqueries, constraints, set operators, views, and data types.

63questions

120minutes

63%to pass

3sets

Start practice →

ORACLE 1Z0-149

Oracle Database Program with PL/SQL

Advanced PL/SQL certification covering blocks, cursors, procedures, functions, packages, triggers, collections, dynamic SQL, and built-in packages.

60%to pass

Oracle Database Administration I

Database architecture, storage, instance management, undo/redo, memory, security, backup & recovery, archiving, and Data Guard.

60%to pass

Azure Database Administrator Associate

Implement and manage SQL-based database solutions on Azure. Performance tuning, HA, security, and automation.

70%to pass

PostgreSQL Associate Certification

Foundational PostgreSQL certification — schemas, indexes, MVCC, replication, performance, and JSON/JSONB.

70%to pass

How certification practice works

Each track contains independent question sets — no overlap, so you can take multiple sessions.
Timer starts on the first question and auto-submits when it hits zero.
Use the question grid to jump between questions; flag any you want to revisit.
Results show your score, pass/fail, weak topics, and per-question explanations.
Progress is stored in your browser only — refreshing during an exam resets it.

Why practise with timed mock exams?

The biggest difference between people who pass an Oracle certification and people who don't isn't knowledge — it's pace. The 1Z0-071 gives you under 2 minutes per question. The 1Z0-082 is almost as tight. Untimed study lets you linger on a question for 10 minutes; the real exam will not. The SQLMentor practice exams replicate the exam's time pressure so you build the speed and intuition you'll need on test day.

What's included with every track

Full-length timed mock exams — same question count and time limit as the real exam.
Multiple independent sets — re-test without memorising the same questions.
Per-question explanations — see why each answer is right or wrong, not just the score.
Flag & review system — mark questions to revisit during the exam, like the real Pearson VUE interface.
Pass/fail status against the real cut score for each exam.
Local-only history — your scores stay in your browser's storage; we don't store any personal data.

Study tips

For best results: study a topic in Learn SQL or Learn PL/SQL, run the related queries in the in-browser editor, then take a timed practice set here. Repeat until you're consistently 5–10% above the pass mark under exam timing — that buffer is what survives nerves on the day.

New to an exam? Each exam guide breaks down the full syllabus, passing score, cost, and a study plan: 1Z0-071, 1Z0-082, 1Z0-149, DP-300, and PostgreSQL Associate.

Still deciding which certification to pursue? See the side-by-side comparison of all five exams, or follow the Oracle certification path from SQL associate to the PL/SQL and DBA tracks.

Frequently asked questions about SQL certifications

Which Oracle SQL certification should I take first?

Start with 1Z0-071. It is the foundational Oracle SQL associate exam and a prerequisite mindset for everything else — joins, DDL, DML, subqueries and views. After 1Z0-071, move to 1Z0-082 (DBA I) if you administer databases or 1Z0-149 (PL/SQL Professional) if you write procedural Oracle code.

Are SQLMentor's practice exams the same as the real exam?

No. Our practice questions are written by the SQLMentor team for educational purposes and are not affiliated with Oracle, Microsoft or EDB. They mirror the official exam format — question style, timing, scoring threshold — so you build exam intuition, but the actual exam content differs.

Do I need to sign up to use the practice exams?

No sign-up, no email, no payment. Every practice set is free and your progress is saved in your browser's local storage only — never uploaded anywhere.

How long should I prepare before attempting the real exam?

Most candidates need 4 to 8 weeks of consistent study. Begin with the relevant tutorial track, then run timed practice sets here in the final 2 weeks. When you can score 5–10% above the pass mark consistently under exam timing, you are ready.

What if I run out of time during a practice exam?

The exam auto-submits when the timer hits zero, exactly like the real Pearson VUE interface. Any unanswered questions are scored as incorrect. The results screen then shows pass/fail status, weak topics and per-question explanations.