当前位置： 071题库 > 【第67题】OCP认证1Z0-071最新考试题库及答案

【第67题】OCP认证1Z0-071最新考试题库及答案

来源：优技培训时间：

071考试不仅是OCP11g的考试科目，同时也是OCP 12c的考试科目，所以关心071考题的同学有很多，对此我们专门收集整理了近期071考试的原题，并对这些考题进行讲解，希望帮助广大考生顺利通过071考试。

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

071考题解析-第67题、choose the best answer:

View the Exhibit and examine the structure of CUSTOMERS table.

Evaluate the following query:

SQL>SELECT cust_id, cust_city

FROM customers

WHERE cust_first_name NOT LIKE 'A_%g_%' AND

cust_credit_limit BETWEEN 5000 AND 15000 AND

cust_credit_limit NOT IN (7000, 11000) AND

cust_city NOT BETWEEN 'A' AND 'B';

Which statement is true regarding the above query?

A) It executes successfully.

B) It produces an error because the condition on the CUST_FIRST_NAME column is not valid.

C) It produces an error because conditions on the GUST_CREDIT_LIMIT column are not valid.

D) It produces an error because the condition on the CUST_CITY column is not valid.

Answer：A

(解析：考语法，验证 not like 、between and、not in、not between and 的混合使用)

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

OCP解析公开课时间：【每周五晚8点】

OCP解析群资料分享：1015267481 验证：ocp

另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与