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
| 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
| 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.)
- A Write each apostrophe inside the literal as two consecutive single quotation marks (correct answer)
- B Precede each apostrophe with a backslash escape character inside the literal
- C Define an ESCAPE character for the statement before the literal is used
- D Enclose the whole literal in double quotation marks instead of single ones
- E Use the q quote operator with a delimiter pair, such as q'[...]', around the text (correct answer)
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?
- A The query prompts for a value and offers IT_PROG as the suggested default
- B The query uses IT_PROG without prompting until the user runs UNDEFINE job (correct answer)
- C The variable is available only in the next statement and then is removed
- D The query compares JOB_ID with the literal text &job, ignoring the DEFINE
Question 3 of 3
What does MONTHS_BETWEEN(DATE '2026-03-31', DATE '2026-02-28') return?
- A 0.9677
- B 1.0333
- C 1.0968
- D 1 (correct answer)
See all 10 free 1Z0-071 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, 1Z0-071 practice test 3
75%
Passed
Pass mark 63%
| Domain | Weight | Your 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.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Displaying Data from Multiple Tables and Managing Tables Using DML Statements, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- 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.
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 |