本文主要向大家介绍了Oracle数据库之【OCP题库】最新CUUG OCP 12c 071考试题库（67题），通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。

67、(25-8)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_firstname 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 的混合使用)

本文由职坐标整理并发布，希望对同学们学习Oracle有所帮助，更多内容请关注职坐标数据库Oracle数据库频道！