Which of the following is not a valid Arithmetic operator in SQL Server?

Does SQL Server support user-defined datatypes?

Which one is not a column property?

Which of the following is not a control statement?

Which one is an invalid statement for manipulation of binary data?

A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) from employees

State which of the following are true

Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if all the parentheses are removed from the calculation?

What is the correct SQL syntax for selecting all the columns where the 'LastName' is alphabetically between (and including) 'Hansen' and 'Pettersen'?

Which is not (a) valid binary datatype in SQL Server?

Which ones are aggregate functions in SQL?