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

___________ is the highest level of a transaction isolation implemented by SQL Server.

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?

Which one is not a SQL operator?