一、原题
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?
![](https://img-blog.csdn.net/20140429112008640?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaG9sbHkyMDA4/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
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
二、题目翻译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_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
下面是CUSTOMERS表的结构
看下面的查询语句:
关于上面的查询哪句话是正确的?
A.执行成功。
B.报错,因为CUST_CITY列的条件无效。
C.报错,因为CUST_FIRST_NAME的条件无效。
D.报错,因为CUST_CREDIT_LIMIT的条件无效。
看下面的查询语句:
关于上面的查询哪句话是正确的?
A.执行成功。
B.报错,因为CUST_CITY列的条件无效。
C.报错,因为CUST_FIRST_NAME的条件无效。
D.报错,因为CUST_CREDIT_LIMIT的条件无效。