【2019年8月版本】OCP 071認(rèn)證考試最新版本的考試原題-5-CUUG整理

OCP的071考試，在8月份左右全部換了新題，近期考試的題也全部不包括之前的題庫了，這次oracle更新071考試題庫，雖然全都是新題，但跟之前的相比也有關(guān)聯(lián)，比如把之前的考題稍微變換一下數(shù)字、更新一下日期、或者再加一個(gè)錯(cuò)誤選項(xiàng)等等。

對(duì)于2019年8月份的更新，我們CUUG已經(jīng)進(jìn)行了收集整理，并給出初步的答案和講解，僅供參考，希望對(duì)考OCP 071認(rèn)證的同學(xué)有幫助。

choose the best answer

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.

The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.

Which query produces output for CUST_LAST_SAME containing Order for the first row and Aus for the second?

A) SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

B) SELECT REPLACE (TRIM(TRALING '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 (SUBSTR(cust_last_name,-3), 'An', 'O') FROM customers;

Answer：A

(解析：經(jīng)過測(cè)試，A 答案能夠打印正確的結(jié)果。)