（54）View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement:

SELECT cust_last_name, cust_city, cust_credit_limit

FROM customers

WHERE cust_last_name BETWEEN 'A' AND 'C'

AND cust_credit_limit BETWEEN 1000 AND 3000;

What would be the outcome of the above statement?

A. It executes successfully.

B. It produces an error because the condition on CUST_LAST_NAME is invalid.

C. It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values.

D. It produces an error because the AND operator cannot be used to combine multiple BETWEEN clauses.

答案：（A）

解析：

可以执行，但结果可能与希望的不一样

ITPub博客

OCP 1Z0-051-54