Oracle Exam 1Z0-082 Topic 10 Question 78 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 78
Topic #: 10

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?

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;

Show Suggested Answer

Suggested Answer: A

by Fatima at Aug 05, 2023, 06:02 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!