You work as a database administrator at ABC.com. You study the exhibit carefully.Exhibit:Evaluate the following query:Ex
Posted: Wed Jun 07, 2023 6:12 am
You work as a database administrator at ABC.com. You study the exhibit carefully.Exhibit:Evaluate the following query:Exhibit: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 MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression
C. The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values
D. The alias NAME should not be enclosed within double quotation marks
- You Work As A D 1 (26.12 KiB) Viewed 167 times
- You Work As A D 2 (15.39 KiB) Viewed 167 times
B. The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression
C. The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values
D. The alias NAME should not be enclosed within double quotation marks