OCP-1Z0-051 第54题

一、原题

View the Exhibit and examine the structure of the CUSTOMERS table.
Evaluate the query statement:
SQL> 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 clause.

答案：A

二、题目翻译

查看CUSTOMERS表结构，下面的查询语句的结果是什么？
A. 上面的语句执行成功。
B. 报错，因为CUST_LAST_NAME的条件是无效的。
C. 如果CUST_CREDIT_LIMIT列没有包含任何null值就可以执行成功。
D. 报错，因为AND操作符不能联合多个BETWEEN子句。