Oracle 1Z1-171 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z1-171
Exam Name/Title: Oracle Database 23ai SQL Associate
Certification Provider: Oracle
Corresponding Certification: Oracle Database

Exam Questions: 111
Updated On: Oct 11, 2026

Question #19

Which SQL clause is used to specify the source table in a query?

A. WHERE

B. GROUP BY

C. FROM

D. SELECT

Discussion 0

Correct Answer: C Vote an answer

Question #20

What does the following query return?
SELECT department_id FROM departments
INTERSECT
SELECT department_id FROM employees;

A. Department IDs that exist in both the departments and employees tables

B. All department IDs from the departments table

C. All department IDs from the employees table

D. Department IDs that exist only in the employees table

Discussion 0

Correct Answer: A Vote an answer

Question #21

Which clause can be used with SET operators to sort the final result set?

A. ORDER BY

B. WHERE

C. HAVING

D. GROUP BY

Discussion 0

Correct Answer: A Vote an answer

Question #22

Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?

A. Arrows

B. Ovals

C. Rectangles

D. Diamonds

Discussion 0

Correct Answer: B Vote an answer

Question #23

What does a Cartesian product in SQL result from?

A. An INNER JOIN without specifying join conditions

B. An OUTER JOIN with NULL values

C. A NATURAL JOIN without specifying join conditions

Discussion 0

Correct Answer: A Vote an answer

Question #24

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;

Discussion 0

Correct Answer: D Vote an answer

Question #25

Which of the following ensures that a relational database enforces data integrity?

A. Indexes on all columns

B. Constraints such as primary keys, foreign keys, and unique constraints

C. Redundant data storage

D. Hierarchical data organization

Discussion 0

Correct Answer: B Vote an answer

Question #26

What is the primary purpose of granting privileges in Oracle Database?

A. To create new tables and indexes

B. To increase query performance

C. To define the structure of database tables

D. To control user access to database objects and operations

Discussion 0

Correct Answer: D Vote an answer

Question #27

Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?

A. Insert rows into multiple tables simultaneously

B. Insert rows into a single table based on values in other tables

C. Insert rows into a table only when a condition is met

D. Insert rows into multiple tables without conditions

Discussion 0

Correct Answer: A Vote an answer

Download Free Oracle 1Z1-171 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z1-171 exam.