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

QUESTION NO: 1
What will the following query do?
SELECT employee_id, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);

A. Return employees with a salary below the average salary B. Return employees with a salary above the average salary C. Return employees with a salary equal to the average salary D. Return all employees and their salaries

Correct Answer: B

QUESTION NO: 2
Which function returns the current system date and time in the database session's time zone?

A. CURRENT_TIMESTAMP B. SYSDATE C. SYSTEM_TIME D. LOCAL_TIME

Correct Answer: A

QUESTION NO: 3
What is the purpose of using external tables in Oracle Database?

A. To manage data stored in external files using SQL B. To create temporary tables for session-specific data C. To store backup copies of database tables D. To improve the performance of complex queries

Correct Answer: A

QUESTION NO: 4
Which command would drop an index from a table?

A. DELETE INDEX B. DROP INDEX C. REMOVE INDEX D. TRUNCATE INDEX

Correct Answer: B

QUESTION NO: 5
What is the primary purpose of a primary key in a relational database?

A. To store duplicate data in a table B. To establish relationships between tables C. To sort data in ascending order D. To uniquely identify each record in a table

Correct Answer: D

QUESTION NO: 6
Which of the following statements is true about constraints in Oracle Database?

A. Constraints can only be added when creating a table. B. Constraints cannot reference other tables. C. Constraints are automatically dropped when rows are deleted. D. Constraints can be added or modified using the ALTER TABLE statement.

Correct Answer: D