Success Forge SQL Server Quiz

Which SQL clause is used to filter groups of rows after they have been grouped by GROUP BY clause?

• ORDER BY

• HAVING

• WHERE

• DISTINCT

Which SQL keyword is used to retrieve data from a database?

• GET

• SELECT

• FETCH

• RETRIEVE

How would you select all employees with salaries between 4000 and 7000 in SQL?

• SELECT * FROM Employees WHERE salary >= 4000 AND salary <= 7000;

• SELECT * FROM Employees WHERE salary BETWEEN 4000 AND 7000;

• Both 1 and 2

• None of the above

What will the following query do?
SELECT department, MAX(salary) FROM Employees GROUP BY department;

• Returns the highest salary in the company

• Returns the highest salary for each department

• Groups all employees by salary

• Returns the total salary in each department

What will the following SQL statement return?
SELECT AVG(salary) FROM Employees WHERE department = 'Marketing';

• The total salary of Marketing department employees

• The average salary of all employees

• The average salary of Marketing department employees

• The sum of salaries in all departments

In a LEFT JOIN, what happens to rows in the left table when no corresponding match in the right table?

• They are excluded from the results

• They appear with NULL values for columns from the right table

• They are duplicated based on the rows in the right table

• They are included only if specified

Which type of join includes only rows with matching values from both tables?

• LEFT JOIN

• INNER JOIN

• FULL JOIN

• RIGHT JOIN

Identify the join in the below statement?
SELECT * FROM Orders LEFT JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

Which operator would you use to select employees with a salary greater than 3000 and working in the 'Sales' department?

• OR

• AND

• NOT

• BETWEEN

What does the GROUP BY clause do in SQL?

• Filters rows based on a specific condition

• Orders rows in ascending order

• Groups rows with the same values in specified columns

• Limits the number of rows returned