State which of the following are true

Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?

Which one 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 not a valid Arithmetic operator in SQL Server?

Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?

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'?