200+ Free Oracle SQL Practice Questions

Pass your Oracle Database SQL Certified Associate (1Z0-071) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

200+ Questions

100% Free

1 / 200

Question 1

Score: 0/0

Which statement best describes the role of a primary key in a relational table?

It stores descriptive text for the table

It uniquely identifies each row in the table

It automatically sorts rows alphabetically

It prevents users from querying the table

to track

2026 Statistics

Key Facts: Oracle SQL Exam

Total Questions

Oracle University

63%

Passing Score

Oracle University

120 min

Exam Duration

Oracle University

US$245

Base Exam Price

Oracle certification guidelines

3-day wait

Retake Delay

Oracle retake policy

11g to 19c

Validation Range

Oracle University

As of March 11, 2026, Oracle University lists the Oracle Database SQL Certified Associate exam 1Z0-071 as a 63-question, 120-minute, multiple-choice exam with a 63% passing score. Oracle's active exam page states the exam is validated for Oracle Database 11.2.0.1.0 up to 19c. Oracle publishes the objective checklist but does not currently publish official domain percentage weightings on that page, so the topic emphasis below is inferred from the breadth of the official objectives.

Sample Oracle SQL Practice Questions

Try these sample questions to test your Oracle SQL exam readiness. 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.

Questions

63 scored questions

Time Limit

120 minutes

Passing Score

63%

Exam Fee

US$245 list price (country-specific) (Oracle University)

Oracle SQL Exam Content Outline

Approx. 14%

Relational Concepts and Basic SELECT

Study relational database fundamentals, normalization, entity relationship concepts, and the core SELECT statement including aliases, literals, DISTINCT, arithmetic expressions, and DUAL.

Approx. 8%

Filtering, Sorting, and Substitution Variables

Apply WHERE conditions, operator precedence, ORDER BY rules, pattern matching, NULL checks, and SQL*Plus-style substitution variables.

Approx. 14%

Single-Row, Conversion, and Conditional Functions

Use character, number, and date functions, nested functions, implicit and explicit conversion, NULL-handling functions, and CASE or DECODE style conditional logic.

Approx. 15%

Joins and Set Operators

Build inner, outer, self, non-equijoins, and cartesian products, then combine result sets correctly with UNION, UNION ALL, INTERSECT, and MINUS.

Approx. 17%

Aggregation, Grouping, and Subqueries

Work with group functions, GROUP BY and HAVING, NULL behavior in aggregates, single-row and multiple-row subqueries, correlated subqueries, and EXISTS logic.

Approx. 12%

DML, MERGE, and Transaction Control

Insert, update, delete, merge, and multitable insert data while understanding COMMIT, ROLLBACK, SAVEPOINT, and transaction visibility.

Approx. 12%

Tables, Data Types, and Constraints

Create, alter, and drop tables, choose Oracle data types, manage constraints, temporary and external tables, and understand TRUNCATE plus unused-column behavior.

Approx. 8%

Schema Objects, Privileges, Dictionary, and Time Zones

Review views, indexes, sequences, synonyms, grants and roles, data dictionary views, and date-time topics such as time zone and interval handling.

How to Pass the Oracle SQL Exam

What You Need to Know

Passing score: 63%
Exam length: 63 questions
Time limit: 120 minutes
Exam fee: US$245 list price (country-specific)

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

Oracle SQL Study Tips from Top Performers

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.

7Aim to score well above 75% on mixed practice sets before scheduling so you have margin over Oracle's 63% passing threshold.

Frequently Asked Questions

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

Oracle University currently lists 1Z0-071 as a 63-question multiple-choice exam with a 120-minute time limit and a 63% passing score. Oracle's active exam page also states the exam is validated from Oracle Database 11.2.0.1.0 up to 19c.

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

Not on the active Oracle University 1Z0-071 page as of March 11, 2026. Oracle publishes the objective list, but the topic percentages in this practice set are estimated from objective breadth rather than copied from an official weighting table.

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's current certification retake policy allows a failed proctored exam retake after 3 days and limits candidates to 4 attempts on the same failed exam within any 12-month period. Each new attempt requires a new exam purchase or included attempt.

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?

I did not find an official Oracle announcement retiring 1Z0-071 or replacing its active exam page as of March 11, 2026. The practical 2026 consideration is that Oracle still labels the exam as validated through 19c, so candidates should focus on core SQL behavior rather than expecting newer 23ai-only features to dominate.