OCP-1Z0-051 第60题

最新推荐文章于 2019-11-24 23:01:39 发布

hello_holly

最新推荐文章于 2019-11-24 23:01:39 发布

阅读量4k

点赞数 2

本文链接：https://blog.csdn.net/holly2008/article/details/24701899

版权

OCP-1Z0-051 专栏收录该内容

220 篇文章 6 订阅

订阅专栏

一、原题

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