071考试既是ocp11g的考试科目，又是ocp12c的考试科目，所以关注的人很多，由于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解析公开课地址：https://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与
