Oracle SQL
Oracle Database SQL
More study resources
Cheat sheet
Keep the key ideas within reach.
ExploreKey terms
Get comfortable with the vocabulary.
ExploreStudy plan
Give each week a clear focus.
ExploreCommon mistakes
Understand the traps and how to avoid them.
ExploreCase studies
Put your knowledge to work in context.
ExploreExam-day guide
Prepare for the day ahead.
ExploreAbout this exam
The Oracle Database SQL Certified Associate credential - commonly referenced by its exam code, 1Z0-071 - is an entry-level certification that validates a candidate's ability to write and reason about SQL against an Oracle Database. It is aimed at developers, junior DBAs, data analysts, report writers, and students who need to prove they can retrieve, filter, transform, aggregate, and modify data using Oracle's SQL dialect rather than a generic one. The exam tests breadth rather than deep administration: single-table SELECT and row filtering, sorting, single-row and conversion functions, conditional logic, group functions and grouping rules, the full range of join syntax including ANSI joins and self-joins, single-row and multi-row subqueries, set operators, transactional DML, and the DDL used to create and manage tables, views, sequences, synonyms, and indexes. Preparation is overwhelmingly hands-on. Reading alone tends to produce shallow recall; candidates who spend most of their time writing queries against a live Oracle instance - Oracle Live SQL, Express Edition, or a cloud free tier - and who deliberately test edge cases such as NULL handling, implicit conversion, and group-by restrictions tend to fare much better. Oracle publishes the current exam objectives, delivery options, pricing, and scoring details on its official certification pages; always reconcile your study plan against those pages before booking.
What you'll study
About Oracle SQL preparation
What is the format of the exam?
It is a multiple-choice certification exam delivered through Oracle's authorized testing partners, either at a test centre or as a remotely proctored session. Some items are scenario-based, presenting a query or table definition and asking for the result or the correction. Confirm the current delivery options on Oracle's official certification site before you schedule.
How hard is it, and do I need prior experience?
There are no formal prerequisites, but the exam assumes comfort with relational concepts. Candidates with a few months of regular SQL practice usually find it manageable. The difficulty comes from precision rather than volume: questions hinge on exact behaviour of NULLs, join types, grouping rules, and function return types, so guessing is unreliable.
How long should I plan to study?
Most candidates who already write SQL daily need a few weeks of focused revision; candidates starting from scratch should budget considerably longer. A practical plan is to work through each objective area, then write queries from scratch on a live database until the syntax and the subtle rules feel automatic rather than memorised.
Can I retake the exam if I fail?
Retake rules, waiting periods, and any associated costs are set by Oracle and can change. Oracle publishes the authoritative retake policy alongside the exam description on its official certification pages, so check there before assuming a specific number of attempts or a specific waiting interval.
What does the exam cost and how long does it take?
Fees and appointment length vary by country, currency, and delivery channel, and they are revised periodically. Rather than relying on second-hand figures, check the current price and duration for the exam on Oracle's official certification website, where the booking partner will also show the time allowance at scheduling.
In what order should I study the topics?
Follow dependency order rather than exam weight. Get single-table SELECT, filtering, and sorting solid first; then single-row and conversion functions; then aggregates and grouping; then joins; then subqueries; then set operators. DML and DDL come last because they reuse everything above. Skipping ahead to joins before grouping is secure is the most common structural mistake.
What are the most common failure modes?
NULL semantics top the list - comparisons with NULL, NULL in aggregates, and NULL in joins. Others are confusing WHERE with HAVING, assuming GROUP BY allows ungrouped select columns, misreading outer joins (especially with filters in the WHERE clause), and mixing up single-row versus multi-row subquery operators. Any of these can silently produce a wrong answer that looks plausible.
Does the certification expire, and is it worth it?
Validity terms and any recertification requirements are defined by Oracle and should be verified on its official certification pages. On value: it is a credible, vendor-specific signal for entry-level SQL roles and a reasonable structured goal for learning Oracle syntax, though it does not replace demonstrable project experience with real schemas and query tuning.
Should I use practice tests?
Yes, but as a diagnostic, not a primary study method. Take one early to find weak areas, then return to hands-on query writing. Be cautious with third-party question sets: many are outdated or contain answers that differ from current Oracle behaviour. Verify any disputed answer by running the SQL on a live instance yourself.