SQL Server Query MCQs

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

• Must come after the GROUP BY clause
• Must come before the GROUP BY clause
• Cannot include any conditions
• Is used to filter out grouping records.

Check Answer

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

• Update Salary = 25000 WHERE EmpId = 3;
• UPDATE Employee SET Salary = 25000 WHERE EmpId = 3;
• UPDATE Employee SET Salary = 25000;
• INSERT Salary = 25000 WHERE EmpId = 3;

Check Answer

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

• INSERT INTO Employee(FirstName, LastName, EMail, PhoneNo, Salary, DeptId)
• INSERT VALUES INTO Employee(FirstName, LastName, EMail, Phone, HireDate, Salary) AS
• INSERT VALUES INTO Employee AS
• INSERT TO Employee VALUES(‘John','King','[email protected]');

Check Answer

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

• DROP TRIGGER TRIGGER dbo. trgEmpUpdate
• DISABLE TRIGGER dbo. trgEmpUpdate
• DELETE TRIGGER dbo. trgEmpUpdate
• DISABLE trgEmpUpdate TRIGGER;

Check Answer

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

• SELECT EmpId AS 'Employee ID', FirstName, DeptID FROM Employee
• SELECT EmpId RENAME 'Employee ID', FirstName, DeptID FROM Employee
• SELECT 'Employee ID', FirstName, DeptID FROM Employee
• A column cannot be given an alias in T-SQL.

Check Answer