Last updated: May 12, 2026. Verified against the active Oracle University 1Z0-071 exam page, Oracle certification policies, Oracle exam preparation guidance, Oracle exam attempt FAQ, and Oracle Database 19c SQL Language Reference.
Start by Ignoring Stale Oracle SQL Exam Facts
The Oracle SQL 1Z0-071 SERP is noisy. Several current-looking pages still repeat older question counts, invent equal domain weights, or push dumps instead of helping candidates understand SQL behavior. That matters because a stale question count changes your pacing plan, and fake weights can send you into the wrong study order.
The active Oracle Database SQL 1Z0-071 exam page is the authority: Oracle lists 63 multiple-choice questions, 120 minutes, and a 63% passing score. The exam is not a general SQL trivia quiz. It is a precision test: can you read Oracle SQL, predict the result set, spot the clause that changes behavior, and choose the statement that satisfies the requirement?
Official 2026 Oracle SQL 1Z0-071 Facts
| Item | Current detail |
|---|---|
| Exam owner | Oracle University |
| Exam number | 1Z0-071 |
| Credential path | Required exam for Oracle Database SQL Certified Associate |
| Format | Multiple choice |
| Questions | 63 |
| Duration | 120 minutes |
| Average pace | About 1 minute 54 seconds per question |
| Passing score | 63% |
| Validation range | Oracle states the exam is validated for Oracle Database 11.2.0.1.0 up to 19c |
| U.S. exam attempt value | Oracle's exam attempt FAQ describes an exam purchase as valued at US$245; final price can vary by country, tax, currency, and subscription route |
| Score report | Oracle says results display at exam close and the detailed score report is available in CertView |
The 63% passing score is not a reason to aim for 64% in practice. Oracle exams can include wording traps, close distractors, and result-prediction questions where one missed NULL or implicit conversion changes the answer. Before scheduling, aim to score comfortably above 75% on mixed sets and above 80% on your historically weak domains.
What 1Z0-071 Actually Measures
Oracle describes the exam as proof of fundamental SQL concepts needed for database work, including queries, insert, update, delete, DDL, data control language, optimizer awareness, tables, indexes, data modeling, and normalization. The practical version is narrower and sharper: you need to understand how Oracle Database evaluates SQL statements.
That means you should not study the objectives as flashcard nouns. Study them as failure modes:
| Official area | What candidates actually need to prove |
|---|---|
| Relational concepts | Understand keys, relationships, normalization, and how SQL maps to an ERD |
| SELECT syntax | Predict projection, aliases, literals, arithmetic expressions, DISTINCT, and NULL results |
| Restricting and sorting | Apply WHERE precedence, LIKE, BETWEEN, IN, NULL tests, substitution variables, and ORDER BY rules |
| Single-row functions | Know character, number, and date function output, especially nested functions |
| Conversion and conditional expressions | Control implicit and explicit conversion with TO_CHAR, TO_NUMBER, TO_DATE, NVL, NULLIF, COALESCE, CASE, and DECODE |
| Group functions | Distinguish COUNT(*) from COUNT(column), GROUP BY from HAVING, and aggregate behavior with NULLs |
| Joins | Choose inner, outer, self, non-equijoin, and cartesian join behavior without guessing |
| Subqueries | Separate single-row, multiple-row, correlated, EXISTS, inline-view, update, and delete subquery patterns |
| Set operators | Match SELECT lists and predict UNION, UNION ALL, INTERSECT, MINUS, and ORDER BY behavior |
| DML and transactions | Understand INSERT, UPDATE, DELETE, MERGE, multitable inserts, COMMIT, ROLLBACK, and SAVEPOINT |
| DDL and table relationships | Create, alter, drop, truncate, define data types, use constraints, temporary tables, external tables, and unused columns |
| Schema objects and access | Work with indexes, synonyms, sequences, views, privileges, roles, data dictionary views, and time-zone data types |
Oracle does not publish official percentage weightings on the active 1Z0-071 page. Treat any page that gives exact weights without explaining the source as a planning aid at best, not an authority. A better plan is to divide prep by risk: high-frequency reasoning topics first, then object and policy topics after the core query engine feels automatic.
The Five Traps That Decide Readiness
1. NULL Is Not a Small Detail
Many 1Z0-071 misses come from NULL behavior. Practice arithmetic with NULL, comparisons to NULL, aggregate functions, outer joins that introduce NULLs, NOT IN subqueries that return NULL, and Oracle functions that replace or test NULL values. If you cannot explain why COUNT(*) and COUNT(column_name) differ, you are not done.
2. Joins and Subqueries Overlap
Candidates often study joins in one chapter and subqueries in another, then freeze when a question can be solved either way. You should be able to tell whether a requirement is about matching row sources, preserving unmatched rows, testing existence, filtering by a returned list, or building an inline result set for the outer query.
3. Conversion Questions Punish Assumptions
Oracle SQL lets implicit conversion happen in many cases, but the exam expects you to know when explicit conversion is safer and what format models do. Train with TO_DATE, TO_CHAR, date arithmetic, number formatting, NVL, COALESCE, and CASE output until you can reason from input value to final expression without running the query.
4. DML and DDL Are Not the Same Kind of Undo
DELETE, TRUNCATE, DROP, COMMIT, ROLLBACK, and SAVEPOINT are easy to confuse if you learned them as vocabulary. Study transaction boundaries and object changes together. Know what can be rolled back, what ends a transaction, and when rows versus table definitions are affected.
5. Oracle-Specific Objects Are Easy Points If You Separate Them
Views, sequences, indexes, synonyms, roles, object privileges, system privileges, dictionary views, intervals, and time-zone functions are not all one bucket. Build a one-page object map: what the object is, what statement creates or changes it, what it does not guarantee, and what privilege or dependency might matter.
A Practical Six-Week 1Z0-071 Study Plan
| Week | Focus | Practice target |
|---|---|---|
| 1 | SELECT, filtering, sorting, aliases, NULL basics, and relational concepts | Finish easy and medium SELECT sets until syntax recognition is automatic |
| 2 | Single-row functions, conversion functions, date arithmetic, and conditional expressions | Drill output-prediction questions, not definition-only questions |
| 3 | Joins, set operators, and result-set matching | Mix inner, outer, self, non-equijoin, UNION, UNION ALL, INTERSECT, and MINUS |
| 4 | Group functions, GROUP BY, HAVING, and subqueries | Review every miss by asking whether it was aggregate logic, row filtering, or subquery cardinality |
| 5 | DML, MERGE, transactions, DDL, data types, constraints, and table relationships | Explain what changes data, what changes objects, and what can be rolled back |
| 6 | Views, indexes, sequences, synonyms, privileges, dictionary views, time zones, and full mixed practice | Take timed 63-question simulations and keep an error log by objective area |
If you already write SQL at work, compress the early syntax weeks and spend more time on Oracle-specific behavior. If you mostly know SQL from PostgreSQL, MySQL, or SQL Server, do not assume portability. 1Z0-071 asks Oracle Database questions, and the official validation range still points candidates toward core Oracle behavior through 19c.
How to Use Practice Without Memorizing Dumps
Oracle's certification guidelines warn against exam content sharing and brain dumps. That is not just a policy issue; dumps are a poor way to learn 1Z0-071 because the exam can change a column, add a NULL, swap IN for EXISTS, or move a predicate from WHERE to HAVING.
- Diagnostic pass: answer mixed questions cold and tag misses by category.
- Repair pass: study the smallest concept that would have fixed each miss, then answer related questions without looking at the explanation first.
- Timed pass: run 63-question blocks in 120 minutes, then review slow correct answers as seriously as wrong answers.
A useful practice explanation should tell you why the correct option works and why the tempting option fails. If a question cannot be explained from SQL semantics, skip it. The real exam rewards reasoning, not answer-shape memory.
Registration, Exam Day, and Score Details
Oracle now routes certification exam registration through Oracle MyLearn and Oracle University exam pages. The Oracle Certification Program Guidelines cover pricing, attempts, scoring, rescheduling, cancellation, and candidate conduct. The Oracle exam preparation page also matters because it spells out online exam readiness requirements such as supported browsers, single-display rules, ID requirements, check-in timing, and prohibited behavior.
Two policy details deserve attention before you pay:
- Oracle's exam attempt FAQ says an exam purchase is an attempt deposited in MyLearn and used to register for a certification exam. It also says purchased exams do not include a free retake.
- Oracle's policy pages can move or be localized by country. Check the active Oracle page and your MyLearn checkout immediately before scheduling, especially for price, expiration, cancellation, rescheduling, and retake timing.
After the exam, Oracle says your result displays on screen and your full score report is available in CertView. If you fail, do not immediately repeat the same study routine. Use the score-domain breakdown to choose the next two repair areas, then rebuild from targeted SQL examples before buying another attempt.
Official Sources to Keep Open
Use Oracle pages, not random prep tables, as the source of truth:
- Oracle Database SQL exam page
- Oracle Database SQL Certified Associate track
- Oracle Certification Program Guidelines
- Oracle University Exam Preparation
- Oracle exam attempt FAQ
- Oracle Database 19c SQL Language Reference
Bottom Line
The Oracle SQL 1Z0-071 exam is easiest to underestimate when you treat it as a beginner syntax test. The official facts are simple: 63 questions, 120 minutes, 63% passing score. The hard part is reading SQL precisely enough to predict Oracle's result under time pressure.
Buy on Amazon