SQL Multiple Choice Questions

What does SQL stand for?

• Structured Query Language

• Sequential Query Language

• Standard Query Language

• Systematic Query Language

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

• GET

• EXTRACT

• SELECT

• RETRIEVE

How do you select all columns from a table named `students`?

• SELECT * FROM students;

• SELECT ALL FROM students;

• SELECT columns FROM students;

• SELECT students;

Which clause is used to filter records in SQL?

• FILTER BY

• WHERE

• HAVING

• ORDER BY

How do you retrieve distinct values from a column named `city` in the `employees` table?

• SELECT UNIQUE city FROM employees;

• SELECT city FROM employees;

• SELECT DISTINCT city FROM employees;

• SELECT DIFFERENT city FROM employees;

What keyword is used to sort the results in ascending order?

• SORT BY ASC

• ORDER BY ASC

• SORT ASCENDING

• ORDER ASC

How do you sort the `customers` table by the `lastname` column in descending order?

• SELECT * FROM customers ORDER BY lastname DESC;

• SELECT * FROM customers SORT BY lastname DESC;

• SELECT * FROM customers ORDER DESC lastname;

• SELECT * FROM customers SORT DESC lastname;

Which SQL function is used to count the number of rows in a table?

• COUNT()

• SUM()

• TOTAL()

• NUMBER()

How do you find the maximum value in a column named `salary`?

• SELECT MAXIMUM(salary) FROM employees;

• SELECT MAX(salary) FROM employees;

• SELECT HIGHEST(salary) FROM employees;

• SELECT TOP(salary) FROM employees;

What clause is used to group rows that have the same values?

• GROUP BY

• ORDER BY

• HAVING

• SORT BY