PracticeVideosBlogFlashcardsEspañol
All Practice Exams

Free Practice Questions for Oracle SQL

Exam-style questions and explanations by OpenExamPrep.

✓ No registration✓ No credit card
200+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

OCI Foundations

Practice QuestionsStudy Guide

Oracle Java SE 21 Developer

Practice QuestionsStudy Guide

Oracle Certified Foundations Associate, Java (1Z0-811)

Practice QuestionsStudy Guide

Oracle DBA

Practice Questions

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

More From This Family

Videos and articles for deeper review.

VideoOracle SQL 1Z0-071 Exam Guide 2026: Active Status, Format, and Study PlanThis examArticleOracle SQL 1Z0-071 Exam Guide 2026: Active Status, Format, and Study Plan15 min read
Exam Review

Key Facts: Oracle SQL Exam

63

Total Questions

Oracle University

63%

Passing Score

Oracle University

120 min

Exam Duration

Oracle University

US$245

Base Exam Price

Oracle certification guidelines

24 hours

Cancel or Reschedule Notice

Oracle exam-attempt FAQ

16 areas

Published Objective Groups

Oracle MyLearn (no percentage weights)

Oracle currently lists 1Z0-071 as an active 63-question, 120-minute, multiple-choice exam with a 63% passing score. It also lists the separate 1Z0-171 Oracle AI Database SQL Associate exam. Confirm the exact code and language before registering. Oracle publishes 16 objective areas for 1Z0-071 but does not publish percentage weights.

Sample Oracle SQL Practice Questions

Try these sample questions to review concepts for the Oracle SQL exam. Each question includes a detailed explanation. Start the interactive quiz above for the full 200+ question experience with AI tutoring.

1Which statement best describes the role of a primary key in a relational table?
A.It stores descriptive text for the table
B.It uniquely identifies each row in the table
C.It automatically sorts rows alphabetically
D.It prevents users from querying the table
Explanation: A primary key uniquely identifies each row in a table and enforces entity integrity. Because primary-key columns cannot contain duplicate or NULL values, they provide a dependable way to reference one specific row.
2Which statement returns every column from the EMPLOYEES table?
A.SELECT ALL FROM employees
B.SELECT * FROM employees
C.GET * FROM employees
D.DISPLAY employees.*
Explanation: The asterisk in SELECT * tells Oracle to return all columns from the referenced table. It is valid SQL syntax, although production code often lists columns explicitly for clarity and stability.
3Which predicate returns rows where SALARY is from 3000 through 5000 inclusive?
A.salary BETWEEN 3000 AND 5000
B.salary IN (3000 TO 5000)
C.salary > 3000 AND < 5000
D.salary RANGE 3000,5000
Explanation: BETWEEN is inclusive on both endpoints in Oracle SQL. That means values equal to 3000 or 5000 are both returned by the condition.
4Which function returns a character expression in uppercase?
A.INITCAP
B.LOWER
C.UPPER
D.ROUND
Explanation: UPPER converts alphabetic characters to uppercase and is often used for case-insensitive comparisons. LOWER performs the opposite transformation, while INITCAP capitalizes the first letter of each word.
5Why is TO_DATE('2026-03-11', 'YYYY-MM-DD') usually safer than relying on implicit conversion?
A.It is shorter to type
B.It avoids dependence on session NLS date format settings
C.It automatically commits the transaction
D.It creates a permanent DATE column
Explanation: Explicit conversion makes the intended format clear to Oracle and avoids surprises caused by session-specific NLS settings. Implicit conversion can succeed in one environment and fail in another.
6What does an inner join return?
A.Only unmatched rows from the left table
B.Rows that satisfy the join condition in both tables
C.All rows from both tables whether they match or not
D.Only duplicate rows
Explanation: An inner join returns only the combinations of rows where the join condition evaluates to TRUE. Unmatched rows from either side are excluded from the result.
7Which set operator removes duplicates when combining two result sets?
A.UNION
B.UNION ALL
C.MINUS
D.INTERSECT ALL
Explanation: UNION combines compatible result sets and removes duplicate rows from the final output. UNION ALL keeps duplicates and is usually faster because no duplicate elimination is needed.
8Which function returns the number of rows, including rows where individual column values are NULL?
A.COUNT(column_name)
B.COUNT(*)
C.SUM(*)
D.AVG(*)
Explanation: COUNT(*) counts rows, not column values, so NULLs in individual columns do not prevent a row from being counted. COUNT(column_name) behaves differently because it ignores NULLs in that specific column.
9Which operator is most appropriate when a subquery is guaranteed to return a single value and you want exact equality?
A.=
B.IN
C.EXISTS
D.LIKE
Explanation: When a subquery returns exactly one value, standard single-row comparison operators such as =, >, or < are appropriate. IN is typically used when multiple rows may be returned.
10Which statement inserts a new row into a table?
A.INSERT
B.ALTER
C.GRANT
D.TRUNCATE
Explanation: INSERT is the DML command used to add new rows to a table. It can insert literal values, sequence-generated values, or rows returned from a subquery.

About the Oracle SQL Exam

Oracle's SQL associate exam focuses on writing and analyzing core Oracle Database SQL across query construction, joins, functions, grouping, subqueries, DML, DDL, constraints, schema objects, and privilege-related basics. Expect questions that test both syntax knowledge and your ability to predict how Oracle handles nulls, joins, conversion, transactions, and object behavior.

Exam sponsor: Oracle University. The requirements and fees below concern the certification or admission exam, separate from our free practice resources.

Questions

63 questions

Time Limit

120 minutes

Passing Score

63%

Exam / Certification Fees

US$245 list price (country-specific)

Exam sponsor website

Fees, eligibility, and exam policies can change. Confirm them with the exam sponsor before applying or paying.

Our practice resources: topics covered

We aim to reflect publicly available exam outlines and topic information in our study resources. Coverage, format, and difficulty may differ from the actual exam, and we cannot guarantee that every detail is accurate or current. Confirm exam requirements, fees, and policies with the official exam sponsor.

Not published

Relational Database Concepts

Relational terminology, entity relationships, table structure, keys, normalization, and the logical model behind SQL queries.

Not published

Retrieving Data with the SQL SELECT Statement

SELECT syntax, projection, aliases, expressions, DISTINCT, and query output.

Not published

Restricting and Sorting Data

WHERE conditions, operator precedence, pattern matching, NULL predicates, substitution variables, and ORDER BY behavior.

Not published

Customizing Output with Single-Row Functions

Character, number, date, and nested single-row functions used to transform query output.

Not published

Conversion Functions and Conditional Expressions

Implicit and explicit datatype conversion, NULL-handling functions, CASE, DECODE, and conditional result logic.

Not published

Reporting Aggregated Data with Group Functions

Aggregate functions, NULL behavior, GROUP BY, HAVING, grouping rules, and filtered aggregate results.

Not published

Displaying Data from Multiple Tables

Inner, outer, self, and non-equijoins, cartesian products, and row-preservation behavior.

Not published

Solving Queries with Subqueries

Single-row, multiple-row, correlated, scalar, and EXISTS-based subqueries, including cardinality and NULL traps.

Not published

Set Operators

UNION, UNION ALL, INTERSECT, and MINUS compatibility, duplicate handling, and final ordering.

Not published

Managing Tables with DML

INSERT, UPDATE, DELETE, MERGE, multitable inserts, transaction control, COMMIT, ROLLBACK, and SAVEPOINT.

Not published

Indexes, Synonyms, and Sequences

Creation, use, behavior, and limitations of common supporting schema objects.

Not published

Managing Tables and Relationships with DDL

CREATE, ALTER, DROP, TRUNCATE, Oracle data types, constraints, temporary tables, and table relationships.

Not published

Views

Simple and complex views, creation rules, DML behavior, and view limitations.

Not published

Controlling User Access

System and object privileges, roles, grants, revokes, and access boundaries.

Not published

Data Dictionary Views

Using Oracle data dictionary views to inspect users, objects, privileges, and metadata.

Not published

Data in Different Time Zones

Datetime and interval data types, time-zone-aware values, conversion, comparison, and display.

Preparing for the Oracle SQL Exam

What You Need to Know

  • Passing score: 63%
  • Exam length: 63 questions
  • Time limit: 120 minutes
  • Exam / certification fees: US$245 list price (country-specific) Official sources

Using Our Practice Resources

  • Work through all 200 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

Oracle SQL: Suggested Study Strategy

1Write real SQL every day instead of only reviewing notes. Oracle SQL questions are easier when SELECT, JOIN, GROUP BY, and subquery syntax feels automatic.
2Treat NULL handling as a separate study topic. Many exam misses come from misunderstanding NULL in arithmetic, comparisons, aggregate functions, or NOT IN subqueries.
3Practice joins and subqueries together. You should be able to explain when a correlated subquery is clearer than a join and when the opposite is true.
4Review DML and transaction control as one topic. Know exactly what COMMIT, ROLLBACK, SAVEPOINT, DELETE, and TRUNCATE do to data, locks, and transaction state.
5Memorize Oracle-specific function behavior only after you understand the pattern. Learn character, number, date, conversion, and conditional functions by seeing input and output.
6Be precise with table design objects. Distinguish PRIMARY KEY, UNIQUE, FOREIGN KEY, CHECK, sequences, views, indexes, synonyms, and temporary or external tables.
7Use mixed timed sets to find recurring SQL reasoning errors; schedule when you can explain every miss instead of relying on a universal readiness percentage.

Frequently Asked Questions

What are the current official exam facts for 1Z0-071?

Oracle currently lists the English 1Z0-071 as a 63-question multiple-choice exam with a 120-minute time limit and a 63% passing score. Confirm your exact language variant before registering.

Does Oracle publish official domain weightings for the Oracle SQL associate exam?

No percentage weights appear beside the 16 areas on Oracle's current 1Z0-071 checklist. This page therefore lists every official area without inventing percentages.

How much does the Oracle SQL exam cost?

Oracle's certification program guidance lists a U.S. base Oracle Technology exam price of US$245, but Oracle notes that pricing can vary by country, tax, and local program rules.

What does Oracle's retake policy look like in 2026?

Oracle states that an exam attempt does not include a free retake, so another registration consumes another attempt. Cancel or reschedule at least 24 hours before the appointment.

How should I study for 1Z0-071 most effectively?

Do not rely on reading syntax lists alone. Practice writing SQL by hand, predicting actual output, handling NULL behavior carefully, and checking why a join, subquery, aggregate, or transaction statement succeeds or fails in Oracle.

Are there any major 2026 Oracle SQL blueprint changes to watch for?

Oracle lists 1Z0-071 and the separate 1Z0-171 concurrently. The Japanese 1Z0-071-JPN page also announces a change from 78 to 63 questions in early December 2026.