Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 37 of 57

Marks: +1, -0

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

SELECT REPLACE (TRIM(TRAILING ‘son’ FROM cust_last_name), ‘An’, ‘O’) FROM customers;
SELECT INITCAP (REPLACE(TRIM(‘son’ FROM cust_last_name), ‘An’, ‘O’)) FROM customers;
SELECT REPLACE (SUBSTR(cust_last_name, -3), ‘An’, ‘O’) FROM customers;
SELECT REPLACE (REPLACE(cust_last_name, ‘son’, ‘’), ‘An’, ‘O’) FROM customers;

Validate

Go to Question:

Prev Question

Next Question