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