Oracle Database 23ai SQL Associate - 1Z1-171 Exam Questions [2026]

QUESTION NO: 1
Which of the following is a valid reason to create a synonym?

A. To improve query performance B. To provide simplified and consistent access to an object C. To enforce unique constraints on a table D. To automatically generate numeric values for a column

Correct Answer: B

QUESTION NO: 2
Which command revokes a user's privilege to update a table?

A. DELETE UPDATE ON table_name FROM user_name; B. REMOVE UPDATE ON table_name FROM user_name; C. DENY UPDATE ON table_name FROM user_name; D. REVOKE UPDATE ON table_name FROM user_name;

Correct Answer: D

QUESTION NO: 3
What is a role in Oracle Database?

A. A user-defined function B. A predefined SQL statement stored in the database C. A database object used to enforce constraints D. A set of privileges that can be granted to users or other roles

Correct Answer: D

QUESTION NO: 4
Which of the following is an example of an object privilege?

A. SELECT ON table_name B. DROP DATABASE C. CREATE TABLE D. ALTER USER

Correct Answer: A

QUESTION NO: 5
What does the UNION ALL operation do when selecting matching columns from different tables?
SELECT employee_id, salary FROM employees
UNION ALL
SELECT employee_id, bonus FROM bonuses;

A. Returns only employees with duplicate employee IDs in both tables B. Returns only the employees with salaries and bonuses C. Combines the salaries and bonuses for employees, removing duplicates D. Combines all employee IDs, salaries, and bonuses, including duplicates

Correct Answer: D

QUESTION NO: 6
What happens when a temporary table is created in Oracle Database?

A. It is permanently stored in the database. B. It is created for the duration of a user session or transaction. C. It cannot have any constraints. D. It is stored in external files.

Correct Answer: B

QUESTION NO: 7
Which clause is used to ensure that only specific rows are deleted in a DELETE statement?

A. FROM B. HAVING C. WHERE D. SET

Correct Answer: C

QUESTION NO: 8
Which clause in an UPDATE statement typically uses a subquery to assign values to columns?

A. FROM B. HAVING C. WHERE D. SET

Correct Answer: D

QUESTION NO: 9
What is the purpose of a correlated subquery?

A. A subquery that depends on the result of another subquery B. A subquery that can be used only with aggregate functions C. A subquery that references columns from the outer query D. A subquery that combines data from multiple tables

Correct Answer: C

QUESTION NO: 10
What will the following query do?
DELETE FROM employees
WHERE department_id = 20;

A. Delete all rows in the employees table B. Delete all rows where department_id is 20 C. Raise an error because DELETE cannot use a WHERE clause D. Delete the department_id column in the employees table

Correct Answer: B