（60）View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query:

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_CITY column is not valid.

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

D. It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.

答案：（A）

ITPub博客

OCP 1Z0-051-60