SQL Basics Quiz

What does SQL stand for?

• Structured Query Language

• Simple Query Logic

• Strong Question Language

• Sequential Query Language

Which command is used to retrieve data from a table?

• GET

• FETCH

• SELECT

• RETRIEVE

Which SQL clause is used to filter records?

• WHERE

• GROUP BY

• ORDER BY

• HAVING

What does the following query do? SELECT * FROM employees;

• Updates all data in the employees table

• Deletes all data from employees table

• Retrieves all columns from the employees table

• Creates a new employees table

What is the purpose of the GROUP BY clause?

• To delete rows in a group

• To group rows that have the same values in specified columns

• To order the rows by column

• To rename columns in a result set

Which query lists all employees in the "Sales" department?

• SELECT * FROM employees WHERE department = 'Sales';

• SELECT department FROM employees;

• SELECT * FROM employees GROUP BY department;

• SELECT * FROM employees WHERE salary > 50000;

You want to count the number of employees in each department. Which query is correct?

• SELECT COUNT(department) FROM employees;

• SELECT department, COUNT(*) FROM employees GROUP BY department;

• SELECT department FROM employees;

• SELECT COUNT(*) FROM employees;

What is the output of this query? SELECT department, COUNT(*) FROM employees GROUP BY department;

• List of all departments only

• List of departments and total number of employees in each

• List of employees with their salaries

• List of all employees

Which of the following will retrieve employees with a salary greater than 60,000?

• SELECT * FROM employees WHERE salary = 60000;

• SELECT * FROM employees WHERE salary > 60000;

• SELECT * FROM employees WHERE salary = 60000;

What does the asterisk (*) represent in a SELECT statement?

• Only primary keys

• All columns

• Column names

• Row numbers