1Z0-071 — Oracle Database SQL Study Plan

Who this Study Plan is for

This Study Plan is for candidates preparing for Oracle Database SQL (1Z0-071), exam code 1Z0-071. It is designed for practical preparation: write SQL, review Oracle-specific behavior, complete mixed practice, and turn missed questions into repeatable fixes.

Use the current Oracle exam page and your registration materials as the source of truth for official scope, timing, and policies. This plan does not assume an official pass mark or weighting. It focuses on how to prepare effectively with the time you have.

Which plan should you use?

Choose the shorter plan only if you already have SQL experience. If you are new to Oracle SQL, use the 60/90-day path even if you know general SQL from another database platform.

Core 1Z0-071 study areas

Organize your study around skills you can demonstrate by writing and explaining SQL. Reading syntax is not enough for Oracle Database SQL (1Z0-071).

Daily practice rhythm

Use the same rhythm regardless of plan length. The difference is how much time you spend in each block.

Standard 90-minute session

Longer 2- to 3-hour session

Short 45-minute session

Start with a diagnostic

Before choosing what to study first, take a mixed diagnostic practice set. Do not spend the first several days rereading everything.

After the diagnostic, sort every miss into one of these buckets:

Your diagnostic result should decide the order of your study. For example, if you missed many join and subquery questions, do not spend two days polishing basic SELECT syntax.

7-day final review sprint

Use this plan if your exam is one week away. The goal is not to learn every topic from scratch. The goal is to remove high-risk weaknesses, improve timing, and avoid repeat mistakes.

7-day rules

• Stop adding broad new material after Day 5.
• On Day 6, the review of missed mock questions is more important than taking another mock.
• On Day 7, do short recall and light practice only.
• If you repeatedly miss the same topic, write and run SQL for it instead of rereading notes.

14-day focused plan

Use this plan if you have two weeks and need both coverage and exam conditioning.

14-day emphasis

Spend the first week repairing foundations. Spend the second week integrating topics in mixed practice. Many 1Z0-071 questions test more than one concept at once, such as a join combined with filtering, grouping, or a subquery.

30-day balanced plan

Use this plan if you want enough time for concept coverage, hands-on SQL, and multiple review cycles.

30-day schedule

60/90-day full preparation path

Use this path if you are newer to SQL, coming from another database platform, or want durable Oracle SQL fluency before taking Oracle Database SQL (1Z0-071).

Weekly rhythm for 60/90 days

Mock placement for longer plans

Do not take a mock exam if you do not have time to review it. For this exam, the review is where much of the learning happens.

Hands-on SQL practice method

For Oracle Database SQL (1Z0-071), hands-on practice should be part of every study week. Use an Oracle SQL environment such as Oracle Live SQL, Oracle SQL Developer with a local database, or another Oracle-compatible practice setup.

When you miss a question, reproduce the behavior. Adapt table and column names to your practice schema.

-- NULL comparison drill
SELECT employee_id, commission_pct
FROM employees
WHERE commission_pct = NULL;

SELECT employee_id, commission_pct
FROM employees
WHERE commission_pct IS NULL;

-- GROUP BY and HAVING drill
SELECT department_id, COUNT(*) AS employee_count
FROM employees
WHERE department_id IS NOT NULL
GROUP BY department_id
HAVING COUNT(*) > 5
ORDER BY employee_count DESC;

-- Subquery behavior drill
SELECT employee_id, last_name, salary
FROM employees
WHERE salary > (
  SELECT AVG(salary)
  FROM employees
);

For each drill, answer these questions:

1. What rows are filtered before grouping?
2. What rows remain after grouping?
3. Which expressions are allowed in the SELECT list?
4. What would change if NULL values were present?
5. What would happen if the subquery returned more than one row?

Missed-question review method

A missed-question log is more valuable than a large pile of unreviewed practice questions.

The 4-pass review cycle

If a question is missed twice, do not just mark it wrong again. Create a small custom drill for that exact issue.

Timed mock exam strategy

Timed mocks are useful only when they simulate pressure and produce review data.

Mock rules

• Use the timing and question count shown in your current Oracle exam registration materials.
• Take the mock in one sitting.
• Do not pause to check syntax.
• Mark uncertain questions so you can review both wrong and lucky-correct answers.
• Spend at least the same amount of time reviewing the mock as you spent taking it.
• Track repeated topics, not just the final score.

Final-week rules

Use the final week to stabilize, not to expand endlessly.

Exam-readiness checks

You are closer to ready when you can do the following without relying on explanations:

• Write basic SELECT, join, aggregate, subquery, and set-operator queries from prompts.
• Explain why NULL changes comparison, grouping, and function results.
• Predict whether a query fails because of grouping, data type, or subquery return rules.
• Distinguish WHERE from HAVING in output questions.
• Choose correct join types based on required row preservation.
• Identify when a subquery must return one row versus multiple rows.
• Explain duplicate handling in set operators.
• Describe the effect of DML and transaction control statements.
• Recognize how constraints, views, sequences, indexes, and synonyms are used.
• Review a missed question and state the corrected rule in one sentence.

If you are still missing many questions from the same two or three areas, delay full-mock repetition and spend a focused session on those topics.

Practical next step

Pick the plan that matches your remaining time, take a mixed diagnostic practice set, and build your missed-question log before doing more review. For Oracle Database SQL (1Z0-071), the fastest improvement usually comes from combining short concept review with hands-on SQL and disciplined review of every missed question.