SQL Server Query MCQs

Question 6: Identify some of the properties of sub-queries in SQL Server

• Must be executed last after executing the main query.
• Must execute first before the main query.
• The subquery must be on the right-hand side of the comparison operator.
• A subquery can include an order by clause.

Check Answer

Question 7: Identify the syntax to delete a column Address from the Employee table

• DELETE COLUMN Address FROM Employee;
• ALTER TABLE Employee DROP COLUMN Address;
• DROP Address FROM Employee;
• ALTER TABLE Employee DELETE COLUMN Address;

Check Answer

Question 8: Considering the following Employee table, write the query that fetches the FirstName whose EmpId is 5.

• Select * from Employee WHERE EmpId = 5;
• Select FirstName from Employee WHERE DeptId = 5;
• Select FirstName from Employee WHERE EmpId = 5;
• Select FirstName from Employee inner join EmpId = 5;

Check Answer

Question 9: Refer to the Employee table below and write a query to fetch the EmpId, FirstName, and LastName of the employee with the first name being in descending order.

• SELECT EmpId, FirstName, LastName FROM Employee ORDER BY FirstName desc
• SELECT EmpId, FirstName, LastName FROM Employee GROUP BY FirstName Desc
• SELECT * FROM Employee ORDER EmpId desc
• SELECT EmpId, FirstName desc, LastName FROM Employee

Check Answer

Question 10: Consider the Employee table with EmpId, FirstName, LastName, Email, DeptId columns and the Department table with DeptId and DeptName columns. Write a query to fetch the FirstName, LastName, and department names.

• SELECT FirstName, LastName , DeptName
• SELECT * FROM Employee emp, Department dept
• SELECT emp.FirstName,emp. LastName , dept.DeptName
• SELECT FirstName, LastName , dept.DeptName

Check Answer