SQL Server Query MCQs

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

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

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

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.

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.