You work as a database administrator at ABC.com. You study the exhibit carefully. Evaluate the following query: The above query produces an error on execution. What is the reason for the error?

Question

Exhibit

Options

• AAn alias cannot be used in an expression
• BThe alias MIDPOINT should be enclosed within double quotation marks for the
• CThe MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL
• DThe alias NAME should not be enclosed within double quotation marks

• A
  77% (27)
• B
  14% (5)
• C
  3% (1)
• D
  6% (2)

No community discussion yet for this question.