2018年的OCP 11g题库解析暂告一段落，关于12c的OCP解析公开课正在进行中，课程包括071、062、063三个科目，这里为您带来的是最新版的071考试题库解析，帮大家顺利通过OCP的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点】，【微信群直播】，可以联系咨询老师进群参与
