SQL Server Query MCQs

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

• CREATE DATABASE 'HR';
• CREATE DB ‘HR’
• CREATE NEW DATABASE ‘HR’
• All of the above

Check Answer

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

• DELETE * FROM Employee WHERE Empid = 5
• DELETE FROM Employee WHERE Empid = 5
• DELETE EMPID FROM Employee WITH EmpId = 5
• DELETE EmpId = 5 FROM Employee

Check Answer

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

• Select AVG(Salary) from Employee WHERE DeptId = All;
• Select Salary from Employee Having Avg(Salary);
• Select DeptID, AVG(salary) from Employee Group by DeptId;
• Select Salary.Average from Employee Order by DeptID;

Check Answer

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

• ADD COLUMN column_name WHERE TABLE = table_name
• ALTER TABLE table_name ADD column_name data_type constraint;
• ALTER table_name ADD column_name constraint;
• ALTER TABLE table_name ADD COLUMN column_name;

Check Answer

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

• SELECT COUNT(*) FROM Employee Having DeptId = 1
• SELECT COUNT(*) FROM Employee WHERE EmpId = 1
• SELECT COUNT(*) FROM Employee WHERE DeptId = 1
• SELECT CNT(*) FROM EmployeeWHERE DeptId = 1

Check Answer

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