一、原题
二、题目翻译
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应该放在双引号里。