SQLMentor // cert practice
// certifications

Certification Practice

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.

65questions
90minutes
60%to pass
3sets
Start practice →
ORACLE 1Z0-082

Oracle Database Administration I

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

60questions
90minutes
60%to pass
3sets
Start practice →
MICROSOFT DP-300

Azure Database Administrator Associate

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

30questions
60minutes
70%to pass
2sets
Start practice →
POSTGRESQL PG-A

PostgreSQL Associate Certification

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

30questions
60minutes
70%to pass
2sets
Start practice →
How certification practice works

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

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.

Frequently asked questions

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.