OCP-1Z0-051 第60题

一、原题

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?

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的条件无效。