Oracle Database 23ai SQL Associate - 1Z1-171 Exam Practice Test

Question 1

What happens when the maximum value of a sequence is reached?

A. An error is raised, and the sequence must be recreated.

B. The sequence resets to the starting value if the CYCLE option is specified.

C. The sequence starts decrementing values.

D. The sequence stops generating values.

Correct Answer: B

Question 2

Which of the following SET operators combines results from two queries and removes duplicates?

A. INTERSECT

B. MINUS

C. UNION

D. UNION ALL

Correct Answer: C

Question 3

Which SET operator returns rows from the first query that are not present in the second query?

A. INTERSECT

B. MINUS

C. UNION

D. UNION ALL

Correct Answer: B

Question 4

Which SQL function can be used to replace NULL values with a specified value?

A. REPLACE

B. NVL

C. COALESCE

D. ISNULL

Correct Answer: B

Question 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. Combines the salaries and bonuses for employees, removing duplicates

B. Combines all employee IDs, salaries, and bonuses, including duplicates

C. Returns only the employees with salaries and bonuses

D. Returns only employees with duplicate employee IDs in both tables

Correct Answer: B

Question 6

Which function is used to extract the year from a date in SQL?

A. TO_YEAR(date)

B. YEAR(date)

C. GET_YEAR(date)

D. EXTRACT(YEAR FROM date)

Correct Answer: D

Question 7

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

A. NULL

B. 300

C. 100

D. 200

Correct Answer: C

Question 8

What happens if a privilege is revoked from a user who has granted the same privilege to others?

A. The privilege is revoked from all other users.

B. The privilege cannot be revoked in this scenario.

C. The privilege is retained by the other users.

D. The privilege is transferred to another user.

Correct Answer: A

Question 9

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

A. OUTER JOIN

B. CROSS JOIN

C. NATURAL JOIN

D. INNER JOIN

Correct Answer: D

Question 10

Which of the following is a valid reason to create a synonym?

A. To enforce unique constraints on a table

B. To automatically generate numeric values for a column

C. To provide simplified and consistent access to an object

D. To improve query performance

Correct Answer: C

Oracle Database 23ai SQL Associate - 1Z1-171 Exam Practice Test

Latest Update

Useful Links

Contact Us