SQL Queries Quiz

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

• INSERT

• UPDATE

• SELECT

• DELETE

Which clause is used to filter records in an SQL query based on a condition?

• WHERE

• GROUP BY

• ORDER BY

• HAVING

Which of the following SQL statements is used to remove rows from a table?

• TRUNCATE

• DELETE

• DROP

• REMOVE

What will the following query do? SELECT COUNT(*) FROM Employee;

• Returns the total number of columns in the Employee table

• Returns the total number of rows in the Employee table

• Returns the number of distinct employees

• Returns the sum of all employee salaries

Which SQL function is used to combine the values of multiple columns into one string?

• CONCAT

• SUM

• LENGTH

• GROUP_CONCAT

In SQL, the INNER JOIN keyword:

• Combines rows from two or more tables where there is a match in the columns being joined

• Returns all rows from the left table

• Returns all rows from the right table

• Combines all rows regardless of whether they match

Which of the following is correct for selecting all columns from a table named Products?

• SELECT all FROM Products;

• SELECT * FROM Products;

• SELECT columns FROM Products;

• SELECT everything FROM Products;

Which SQL keyword is used to sort the result-set in ascending or descending order?

• SORT BY

• GROUP BY

• ORDER BY

• HAVING

What is the output of the following query? SELECT MAX(Salary) FROM Employee;

• The highest salary in the Employee table

• The total salary of all employees

• The minimum salary in the Employee table

• The average salary of all employees

Which of the following SQL statements is used to add a new column to an existing table?

• MODIFY TABLE

• ADD COLUMN

• ALTER TABLE

• INSERT INTO