Oracle SQL 1Z0-071 Exam Guide 2026: Active Status, Format, and Study Plan

Last verified: July 30, 2026. Oracle currently lists both 1Z0-071 and the separate 1Z0-171 SQL associate exam. Confirm the code, language, and delivery route in MyLearn before buying an attempt.

Short Answer: 1Z0-071 Is Still Active, but It Is No Longer Oracle's Only SQL Associate Exam

Oracle still lists Oracle Database SQL 1Z0-071 in its current certification catalog and links it to an active Oracle MyLearn exam page. For the English Oracle-delivered exam, the published format is 63 multiple-choice questions in 120 minutes with a 63% passing score.

That statement needs two qualifications that most 2026 guides omit:

• Oracle also lists Oracle AI Database SQL Associate 1Z0-171 as a separate current exam. Its existence does not prove that 1Z0-071 has retired; both appear in Oracle's live catalog.
• The Japanese 1Z0-071-JPN variant still has 78 questions as of July 30, 2026. Oracle Japan says it will change to 63 questions in early December 2026. Its time limit remains 120 minutes and its passing line remains 63%.

If your registration says 1Z0-071, use this guide. If it says 1Z0-171 or 1Z0-071-JPN, open that exact exam page before using any pacing calculation. A current year in a third-party page title does not make its question count current.

200 free Oracle SQL practice questionsPractice questions with detailed explanations

Which Oracle SQL Exam Should You Choose?

The global Oracle certification catalog is the strongest status check because it currently links both 1Z0-071 and 1Z0-171. Oracle Academy separately states that passing 1Z0-071 earns the Oracle Database SQL Certified Associate credential. Do not call 1Z0-071 retired merely because 1Z0-171 exists, and do not treat the two codes as interchangeable.

Verified 1Z0-071 Exam Facts

The US$245 figure is an exam-attempt value, not a guaranteed checkout total worldwide. Oracle's pricing policy says currency and vendor arrangements vary by country. Japanese Pearson VUE pricing and delivery rules are different from Oracle-delivered English exams, so use the checkout attached to your exact code.

Oracle's FAQ describes associate-level preparation as involving at least six months of experience with the product. That is readiness guidance, not a separate course prerequisite published for 1Z0-071. Hands-on SQL matters because the exam asks you to reason about statements, results, and object behavior rather than recognize glossary definitions.

The Official Checklist Has 16 Areas and No Published Weights

Oracle's active checklist groups the scope into these areas:

1. Relational database concepts
2. Retrieving data with the SQL SELECT statement
3. Restricting and sorting data
4. Customizing output with single-row functions
5. Conversion functions and conditional expressions
6. Reporting aggregated data with group functions
7. Displaying data from multiple tables
8. Solving queries with subqueries
9. Set operators
10. Managing tables with DML
11. Indexes, synonyms, and sequences
12. Managing tables and relationships with DDL
13. Views
14. Controlling user access
15. Data dictionary views
16. Data in different time zones

Oracle does not publish percentage weights beside those areas. Avoid prep tables that turn the 16 headings into invented equal weights or precise percentages. Study in dependency order: query construction first, then functions and result-set logic, then data changes and schema objects.

A Dependency-Based Study Order

This order is more defensible than a fabricated weight chart because each phase supports the next. If a diagnostic shows that you already write accurate joins and subqueries, move directly to the Oracle-specific object, privilege, transaction, and time-zone details you use less often.

Six SQL Traps Worth Testing in a Real Database

1. NULL changes arithmetic, comparisons, and NOT IN

NULL is unknown, not zero or an empty label. Arithmetic with NULL normally returns NULL; comparison requires IS NULL or IS NOT NULL; and a NOT IN subquery containing NULL can prevent the result you expected. Compare COUNT(*) with COUNT(nullable_column) on the same data.

2. Alias scope is clause-specific

A select-list alias is useful in ORDER BY, but it is not available to the same query block's WHERE clause. Practice identifying whether an option fails during parsing or merely returns a different result.

3. Implicit conversion depends on assumptions you should make explicit

Practice TO_CHAR, TO_NUMBER, and TO_DATE with format models. When a question supplies text and date or numeric expressions, identify the datatypes before predicting the result. Do not project your PostgreSQL, MySQL, or SQL Server habits onto Oracle.

4. Joins and subqueries must preserve the required rows

An inner join, outer join, EXISTS, scalar subquery, and IN condition can look interchangeable until unmatched rows, duplicates, or NULL values appear. Write a five-row counterexample for each tempting choice.

5. DML and DDL have different transaction consequences

DELETE changes rows and can be rolled back before commit. TRUNCATE is DDL and cannot be rolled back in the same way. Oracle DDL also creates implicit commit boundaries. Test each statement in a disposable schema rather than memorizing a slogan.

6. A schema object does less than its name suggests

An index does not promise a particular query plan, a synonym does not grant privileges, and a view does not automatically make every underlying operation legal. Separate object definition, access rights, dependencies, and optimizer choices.

Use the Oracle Database 19c SQL Language Reference to resolve syntax and behavior questions. It is a better authority than an unexplained answer key.

Build a Small Lab Instead of Reading Syntax in Isolation

Create a disposable schema with employees, departments, jobs, locations, and orders. Seed deliberate edge cases: one unmatched department, duplicate salaries, a NULL commission, an employee without orders, and two timestamps in different zones.

Then complete these work products:

• Write a join that preserves departments with no employees, and explain why moving a predicate between ON and WHERE changes the result.
• Compare IN, EXISTS, NOT IN, and NOT EXISTS with and without a NULL in the subquery.
• Produce grouped results with both WHERE and HAVING, then explain which rows each clause removes.
• Run INSERT, UPDATE, DELETE, SAVEPOINT, ROLLBACK, and COMMIT in a controlled sequence and record the visible state.
• Create a view, sequence, index, and synonym; grant only the minimum required object privilege; then test what remains inaccessible.
• Query dictionary views for your objects and compare CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP in a changed session time zone.

A lab is complete only when you can predict the result before execution and explain any difference afterward. That feedback loop targets the reasoning skill the exam requires.

A Six-Week Plan With Concrete Outputs

Do not convert this schedule into an unsupported claim that everyone needs six weeks. Compress it if your diagnostic is strong; repeat a phase if you cannot explain its misses.

Pacing Depends on the Variant You Registered

For the 63-question English exam, the mathematical average is about 1 minute 54 seconds per item. A workable approach is to answer direct syntax and concept questions first, flag long result-set traces, and preserve a final review window. Oracle does not say you must spend equal time on every question.

For the current 78-question Japanese exam, the average is about 1 minute 32 seconds. That changes only after Oracle Japan's announced early-December 2026 reduction to 63 questions. The registration confirmation, not a generic prep page, controls your pacing plan.

200 Oracle SQL practice questionsPractice questions with detailed explanations

1. Diagnostic: take a mixed set without notes and tag each miss to one of the 16 official areas.
2. Repair: reproduce the relevant SQL in your lab and write why every distractor fails.
3. Timed: build simulations using the question count shown for your exact exam variant and review slow correct answers as well as misses.

A practice percentage is not an Oracle score prediction. Oracle says each exam version's passing score is set independently, and its score report provides an overall result plus domain performance. Use practice to find reasoning defects, not to promise a pass.

Registration and Exam-Day Checks

Oracle routes the English exam through MyLearn. Its certification page says an exam attempt must be taken within six months, while the attempt FAQ says purchased attempts do not include a free retake. Reschedule or cancel at least 24 hours before the appointment to avoid risking the attempt.

For an Oracle-delivered online exam, Oracle's exam preparation page currently requires a supported Windows or macOS system, current Chrome or Edge, at least 8 GB RAM, a reliable connection, a working camera and microphone, and a single display. Run the readiness check on the same device and network you will use. Check in at least 30 minutes early. Paper notes are prohibited; the platform provides a digital whiteboard.

Those instructions explicitly do not govern exams delivered by Pearson VUE. Japanese and Chinese delivery can follow different rules, so use the confirmation for your exact exam.

At exam close, Oracle says the result appears on screen and the detailed score report becomes available in CertView. The report will not reveal which individual questions you missed, but its domain breakdown can direct your next study cycle.

Avoid Dumps and Unsupported Certainty

Oracle treats using or sharing actual exam content as misconduct. Dumps also fail as preparation because a changed predicate, datatype, NULL, or join condition changes the answer. Use original questions, official documentation, and SQL you can execute and explain.

Also reject claims that Oracle publishes a first-attempt pass rate, fixed domain percentages, or a universal raw number of correct answers for 1Z0-071. The official pages reviewed for this guide publish the passing percentage and objectives, not those extra numbers.

Official Sources

• Oracle global certification catalog
• Oracle MyLearn 1Z0-071 exam route
• Oracle MyLearn 1Z0-171 exam route
• Oracle Academy professional certifications
• Oracle Certification Program Guidelines
• Oracle University Exam Preparation
• Oracle exam-attempt FAQ
• Oracle Japan 1Z0-071-JPN exam page
• Oracle Japan May 18, 2026 change notice
• Oracle Database 19c SQL Language Reference

Bottom Line

1Z0-071 remains active, but you must distinguish it from 1Z0-171 and from the Japanese 1Z0-071-JPN variant. Verify the exact code first. Then prepare from Oracle's 16-area checklist without invented weights, run the SQL you are learning, and use timed practice to repair NULL, conversion, join, subquery, transaction, schema-object, privilege, and time-zone mistakes.