【2019年8月】OCP071认证考试最新版本的考试原题第31题

database

Choose two

Examine the data in the CUST NAME column of the CUSTOMERS table:

CUST_NAME

------------------------------

Renske Ladwig

Jason Mallin

Samuel McCain

Allan MCEwen

Irene Mikkilineni

Julia Nayer

You want to display the CUST_NAME values where the last name starts with Mc or MC.

Which two WHERE clauses give the required result?

A) WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name," ") +1 ) ) IN ("MC%", "Mc%)

B) WHERE UPPER (SUBSTR(cust_nane, INSTR(cust_name, " ") +1 ) ) LIKE UPPER("MC%")

C) WHERE INITCAP(SUBSTR(cust_nane, INSTR(cust_name," ") +1 ) ) LIKE "Mc%"

D) WHERE SUBSTR(cust_name,INSTR(cust_name," ") +1 ) LIKE "Mc%" OR "MC%"

E) WHERE SUBSTR(cust_name, INSTR(cust_name," ") +1 ) LIKE "Mc%"

Anser：BC

(解析：原来第 66 题，此题的变化是多了 Answer：B。注意 instr 和 substr 的用法，没有实验还是很难理解的。

Answer：C