OCP-1Z0-051 第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 alias 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 alias MIDPOINT should be enclosed with in double quotation marks for the
CUST_CREDIT_LIMIT/2 expression.

答案：A

二、题目翻译

查看CUSTOMERS表的数据,看下面的查询语句：
SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAX LOWER LIMIT"
     FROM customers;
上面的语句在执行时会产生一个错误。
错误原因是什么？
A. 别名不能用在表达式里
B. 别名不应该附在双引号里
C. MIDPOINT+100表达式给出一个错误，因为CUST_CREDIT_LIMIT包含空值。
D. 关于CUST_CREDIT_LIMIT/2表达式，别名MIDPOINT应该放在双引号里。