SQL will default to a field name if no alias is specified when performing arithmetic. Select the correct default field name that would appear. Select the correct answer

Is it mandatory for alias of a column to have a name different than the name of column being aliased?YesNo

Question 4Fill in the blank: Aliasing involves _____ naming a table or column to make a query easier to read and write.

Which of the following is not a valid SQL type?FLOATNUMERICDECIMALCHARACTER

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________ASCDESCThere is no default valueNone of the mentioned

Observe this table.    The above query produces an error on execution. What is the reason for the error?Select one:a.The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expressionb.An alias cannot be used in an expressionc.The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL valuesd.The alias NAME should not be enclosed within double quotation marks