1Z0-082 Exam Dumps | The customers table has a cust_last_name column of data type varchar2. The table has two rows whose "jst_last

<< Prev Question Next Question >>

Question 22/46

The customers table has a cust_last_name column of data type varchar2.
The table has two rows whose "jst_last_name values are Andersen and Ausson.
Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

A. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;

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

C. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

D. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

Question 22/46

LEAVE A REPLY

Download PDF File