Exam 1z0-082 topic 1 question 146 discussion

Actual exam question from Oracle's 1z0-082

Question #: 146
Topic #: 1

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?

A. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
B. SELECT REPLACE(TRIM(TRAILING 'son' FROM cust_last_name), 'An', 'O') FROM customers;
C. SELECT INITCAP(REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O')) FROM customers;
D. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O') FROM customers;

Show Suggested Answer

Suggested Answer: D 🗳️

by j_tw at April 28, 2023, 2:51 a.m.

Comments

Submit Cancel

musafir

12 months ago

Selected Answer: D

D is correct

upvoted 2 times

...

Darkseid1231

1 year ago

D is correct

upvoted 1 times

...

auwia

1 year ago

Selected Answer: B

Provided answer is correct

upvoted 1 times

auwia

1 year ago

D I'm sorry

upvoted 2 times

...

bllu

1 year, 2 months ago

Selected Answer: D

D is correct

upvoted 1 times

...

j_tw

1 year, 2 months ago

I think B also can be the answer. TRIM(TRAILINIG 'son' from CUST_LAST_NAME) command will delete 'son' from right side. Than Anderson will be Ander, and Ausson will be Aus.

upvoted 1 times

auwia

1 year ago

Trim/trailing works with 1 character only. D is correct.

upvoted 3 times

...