Question 14

Question

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.
Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the
second?

Accepted Answer

SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

SofiaD · Answer

Actually, option A is the right pick here. The double REPLACE removes 'son' first and then swaps 'An' with 'O'. It's straightforward string manipulation, no need for TRIM or SUBSTR in this scenario. Correct me if I'm missing something.

Ben S. · Answer

C or D. I feel like using TRIM or SUBSTR should work here since we're just modifying the endings. Saw something close to this on a practice test, and substring usually solves these cases.

Sofia S. · Answer

Totally get the confusion, but it's A. The nested REPLACE covers both changes in a single query.

Oracle 1Z0-071 Real Exam Questions [October 2026 Update] Quiz

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose COST_LAST_MANE values are Anderson and Ausson. Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

Premium Access Includes