Oracle Database 23ai SQL Associate (1Z0-171) Free Practice Test

Question 1

Which command creates a new role in Oracle Database?

A. CREATE NEW ROLE role_name;

B. ADD ROLE role_name;

C. CREATE ROLE role_name;

Correct Answer: C

Question 2

Which data dictionary view lists all indexes created by the current user?

A. USER_INDEXES

B. DBA_INDEXES

C. ALL_INDEXES

D. INDEX_LIST

Correct Answer: A

Question 3

Which type of join retrieves only the rows with matching values in both tables?

A. INNER JOIN

B. CROSS JOIN

C. NATURAL JOIN

D. OUTER JOIN

Correct Answer: A

Question 4

What will the following query return?
SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') AS formatted_date FROM dual;

A. An error

B. The current date in the format 'DD-MM-YYYY'

C. The time part of the current date

D. The current date in the default system format

Correct Answer: B

Question 5

What is the result of the following SQL query?
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;

A. 100

B. 300

C. 200

D. NULL

Correct Answer: A

Question 6

What is the purpose of the DBA_OBJECTS data dictionary view?

A. To monitor system performance

B. To provide information about all objects in the database

C. To show the current session details

D. To list all users in the database

Correct Answer: B

Welcome to TestSimulate