SQL Server Query MCQs

Question 1: Which of the following T-SQL creates a database?

Question 2: Considering the Employee table below, how will you delete a record whose EmpId is 5?

Question 3: From the Employee table below, how do you get the average salary of each department?

Question 4: Which of the following is a valid T-SQL statement to add a new column to a table?

Question 5: How do you get the total number of employees whose DeptId is 1 from the Employee table given below: