SQL Server Query MCQs

Question 11: What are the characteristics of the HAVING clause?

Question 12: Consider the Employee table below. Write a query to change the salary of an employee whose EmpID is 3 to 25000.

Question 13: Which of the following query inserts a row in the Employee table?

Question 14: Write a query to disable a trigger trgEmpUpdate on the Employee table.

Question 15: How do you include an alias name for the EmpID column of the Employee table in a SELECT statement in SQL Server?