Oracle
1Z0-071 · Question #354
1Z0-071 Question #354: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #354. The question stem and answer options stay visible for context.
Question
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?
Options
- ASELECT REPLACE (TRIM(TRAILING
son' FROM cust_last_name),An', `O') FROM customers; - BSELECT INITCAP (REPLACE(TRIM(
son' FROM cust_last_name),An', `O')) FROM customers; - CSELECT REPLACE (SUBSTR(cust_last_name, -3),
An',O') FROM customers; - DSELECT REPLACE (REPLACE(cust_last_name,
son','),An',O') FROM customers;
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.