SQL Server Query MCQs

Question 21: Select the query to increase and update the Salary of all employees by 20% in the Employee table.

• INSERT INTO Employee VALUES Salary = Salary + (Salary * 20/100);
• UPDATE Employee SET Salary = Salary + (Salary * 20/100);
• SELECT Employee UPDATE Salary AS (Salary * 20/100);
• SET Salary = 20% * Salary FROM Employee

Check Answer

Question 22: Write a query to copy all data from table1 to table2.

• INSERT INTO table2 SELECT * FROM table1
• INSERT INTO table2 VALUES FROM table1
• INSERT FROM table1 VALUES FROM table2
• INSERT VALUES TO table2 FROM table1

Check Answer

Question 23: Write a query to fetch records having the lowest 3 salaries from the Employee table.

• SELECT TOP 3 FROM Employee ORDER BY Salary DESC;
• SELECT TOP 3 * FROM Employee ORDER BY Salary ASC;
• SELECT BOTTOM 3 * FROM Employee ORDER BY Salary DESC;
• SELECT * FROM Employee WHERE COUNT(*) = 3 ORDER BY Salary DESC;

Check Answer

Question 24: Identify the valid SQL statement to display the number of employees in each department whose average salary is greater than 25000.

• SELECT DeptId, COUNT(EmpId) as EmployeeCount FROM Employee GROUP BY DeptId WHERE AVG(Salary) > 25000
• SELECT DeptId, COUNT(EmpId) as EmployeeCount FROM Employee GROUP BY DeptId, Salary WITH AVG(Salary) > 25000
• SELECT DeptId, COUNT(EmpId) as EmployeeCount FROM Employee GROUP BY DeptId HAVING AVG(Salary) > 25000
• SELECT DeptId, COUNT(EmpId) as EmployeeCount FROM Employee ORDER BY DeptId HAVING AVG(Salary) > 25000

Check Answer