1Z0-071

Oracle Database SQL 1Z0-071 practice exams

305 questions in 5 timed practice tests. Each test has about 63 questions and a 120-minute limit. The pass mark is 63%. Results are split across the 16 exam domains.

Exam at a glance

1Z0-071 practice exam settings
Practice tests 5
Questions in total 305
Questions per test About 63
Time limit per test 120 minutes
Pass mark 63%
Question types Single answer and multiple answer (31 multiple-answer questions)
Level Associate
Category Data & Analytics

These are the settings of our practice tests. Check the official Oracle exam page for the current exam format before you book.

Domains and weights

1Z0-071 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Relational Database Concepts 3% 9
Retrieving Data Using the SQL SELECT Statement 6% 18
Restricting and Sorting Data 8% 24
Using Single-Row Functions to Customize Output 8% 24
Using Conversion Functions and Conditional Expressions 8% 24
Reporting Aggregated Data Using Group Functions 8% 24
Displaying Data from Multiple Tables 9% 28
Using Subqueries to Solve Queries 8% 24
Using SET Operators 6% 18
Managing Tables Using DML Statements 9% 28
Managing Indexes, Synonyms and Sequences 6% 19
Using DDL to Manage Tables and Their Relationships 8% 24
Managing Views 4% 13
Controlling User Access 4% 13
Managing Objects with Data Dictionary Views 3% 9
Managing Data in Different Time Zones 2% 6

Sample questions

Question 1 of 3, choose 2

A character literal in a SELECT statement must contain apostrophes, as in the text O'Neil's account. Which TWO techniques produce such a literal in Oracle SQL? (Choose two.)

  1. A Write each apostrophe inside the literal as two consecutive single quotation marks (correct answer)
  2. B Precede each apostrophe with a backslash escape character inside the literal
  3. C Define an ESCAPE character for the statement before the literal is used
  4. D Enclose the whole literal in double quotation marks instead of single ones
  5. E Use the q quote operator with a delimiter pair, such as q'[...]', around the text (correct answer)
Why: The alternative quoting mechanism q'[...]' (or another delimiter pair) lets apostrophes appear freely in the text, and a doubled single quotation mark inside a normal literal is read as one apostrophe. Oracle does not treat backslash as an escape character in literals. Double quotation marks delimit identifiers rather than strings, and the ESCAPE clause applies only to wildcard characters in a LIKE condition.

Question 2 of 3

A SQL*Plus user runs DEFINE job = 'IT_PROG' and then executes a query containing WHERE job_id = '&job'. Which statement is true?

  1. A The query prompts for a value and offers IT_PROG as the suggested default
  2. B The query uses IT_PROG without prompting until the user runs UNDEFINE job (correct answer)
  3. C The variable is available only in the next statement and then is removed
  4. D The query compares JOB_ID with the literal text &job, ignoring the DEFINE
Why: DEFINE creates a substitution variable with a value, so references to &job are replaced with IT_PROG without a prompt for as long as the variable stays defined, which is until UNDEFINE or the end of the session. SQL*Plus does not offer defaults in prompts. Substitution happens before the statement is sent, so &job is not treated as literal text, and the variable is not limited to one statement.

Question 3 of 3

What does MONTHS_BETWEEN(DATE '2026-03-31', DATE '2026-02-28') return?

  1. A 0.9677
  2. B 1.0333
  3. C 1.0968
  4. D 1 (correct answer)
Why: When both dates are the last days of their months, MONTHS_BETWEEN returns a whole number, so the result is exactly 1. The fractional values come from treating the day difference as a fraction of a 31-day month, which Oracle does not do in this case. The value 1.0333 would add the three-day gap between the 28th and the 31st as a fraction, which the last-day rule also prevents.

What your score report looks like

Example attempt, 1Z0-071 practice test 3

75%

Passed
Pass mark 63%

Score by exam domain
DomainWeightYour score%
Relational Database Concepts 3%
88
Retrieving Data Using the SQL SELECT Statement 6%
81
Restricting and Sorting Data 8%
76
Using Single-Row Functions to Customize Output 8%
58
Using Conversion Functions and Conditional Expressions 8%
84
Reporting Aggregated Data Using Group Functions 8%
72

Study next: Using Single-Row Functions to Customize Output. It is below the pass mark and carries 8% of the exam.

Domains and pass mark from our 1Z0-071 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Displaying Data from Multiple Tables and Managing Tables Using DML Statements, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the 1Z0-071 practice exams

Are these real 1Z0-071 exam questions?
No. We write every question ourselves and map it to the published 1Z0-071 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Oracle. 1Z0-071 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
1Z0-083Oracle DBA II 1Z0-083 Oracle Professional 300 110 $14.99
1Z0-1072-26OCI Architect Associate 1Z0-1072-26 Oracle Professional 300 90 $14.99
1Z0-1158-26Oracle Cloud Infrastructure Enterprise AI Pro 1Z0-1158-26 Oracle Professional 250 90 $14.99
1Z0-149Oracle Database PL/SQL Developer Pro 1Z0-149 Oracle Professional 300 90 $14.99
1Z0-997-26OCI Architect Professional 1Z0-997-26 Oracle Professional 300 90 $14.99
1Z0-1085-26OCI Foundations 1Z0-1085-26 Oracle Foundational 200 60 $9.99