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

Evaluate the following query:

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 within double quotation marks for the CUST_CREDIT_LIMIT/2 expression .

答案：（A）

ITPub博客

Oracle Certificate Profession 1Z0-051-15