Oracle
1Z0-082 · Question #151
1Z0-082 Question #151: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #151. 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 "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?
Options
- ASELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
- BSELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
- CSELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;
- DSELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;
Unlock 1Z0-082 to see the answer
You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 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.