15.View the Exhibit and examine the data in the CUSTOMERS table.

最新推荐文章于 2023-05-04 09:36:45 发布

今年我18

最新推荐文章于 2023-05-04 09:36:45 发布

阅读量1.2k

点赞数

分类专栏： 1z0-051 文章标签： 1z0-051 oracle

本文链接：https://blog.csdn.net/dwj19830118/article/details/50548883

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

15.View the Exhibit and examine the data in the CUSTOMERS table.

Evaluate the following query:
SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAX
LOWER LIMIT"
FROM customers;
The above query produces an error on execution.
What is the reason for the error?
A.An alias cannot be used in an expression.
B.The a lias NAME should not be enclosed with in double quotation marks .
C.The MIDPOINT+100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values.
D.The a lias MIDPOINT should be enclosed with in double quotation marks for the CUST_CREDIT_LIMIT/2 expression .
答案:A
解析：这个考察的是别名，别名不能用于select 中的选择的列，不能用于where，可以用于order by
A：正确，MIDPOINT+100这里有问题
B：错误，NAME可以使用双引号引起来，双引号引起来后可以表示小写，或特殊字符
C：错误，MIDPOINT+100是这个导致的错误，但是不是因为null值
D：错误，这里说是因为MIDPOINT应该加上双引号，显然不是这个问题