WorksheetsSQL Quiz
Total questions: 45
Worksheet time: 45mins
What is SQL used for?
Graphic design
Creating websites
Video editing
Storing and retrieving data in databases
Which of the following is a popular database system for SQL?
Photoshop
Word
MySQL
Excel
What does the SQL function AVG() do?
Calculates the average value in a column
Counts the number of rows
Finds the maximum value
Sorts the data
What does the SQL keyword SELECT do?
Deletes data from a database
Retrieves data from a database
Inserts data into a database
Updates data in a database
Which SQL function is used to find the maximum value in a column?
COUNT
SUM
MIN
MAX
What is the purpose of SQL Joins?
Update rows in a table
Delete rows from a table
Combine rows from two or more tables based on a related column between them
Insert new rows into a table
What does the SQL keyword WHERE do?
Selects all records from a table
Groups records based on a column
Sorts records in ascending order
Filters records based on specified conditions
Which SQL function is used to count the number of rows in a table?
AVG
MAX
COUNT
SUM
What is the purpose of SQL GROUP BY?
Groups rows that have the same values into summary rows
Deletes duplicate rows from a table
Inserts new rows into a table
Updates existing rows in a table
Which SQL keyword is used to retrieve unique records?
FILTER
SORT
UNIQUE
DISTINCT
What does the SQL function SUM() do?
Calculates the sum of values in a column
Finds the average value
Counts the number of rows
Sorts the data
What is the purpose of SQL ORDER BY?
Filters records based on conditions
Sorts the result set in ascending or descending order
Selects all records from a table
Groups records based on a column
Which SQL function is used to find the minimum value in a column?
MAX
SUM
MIN
COUNT
What does the SQL keyword INSERT INTO do?
Adds new records to a table
Deletes records from a table
Updates existing records in a table
Selects records from a table
Which SQL keyword is used to combine the result set of two or more SELECT statements?
ORDER BY
GROUP BY
UNION
JOIN
What is the purpose of SQL HAVING clause?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Applies a filter condition to groups of rows
What is the purpose of SQL DISTINCT keyword?
Deletes duplicate rows from a table
Groups rows that have the same values into summary rows
Inserts new rows into a table
Retrieves unique records from a result set
What does the SQL function COUNT() do?
Calculates the average value in a column
Counts the number of rows
Finds the maximum value
Sorts the data
What is the purpose of the SQL keyword UPDATE?
Deletes records from a table
Updates existing records in a table
Inserts new records into a table
Retrieves data from a database
Which SQL function is used to concatenate two or more strings?
CONCAT
JOIN
COMBINE
STRING
What does the SQL keyword DELETE do?
Updates existing records in a table
Deletes records from a table
Inserts new records into a table
Retrieves data from a database
What is the purpose of the SQL keyword WHERE?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Applies a filter condition to groups of rows
Which SQL function is used to find the average value in a column?
COUNT
SUM
MIN
AVG
What is the purpose of SQL LIMIT clause?
Deletes duplicate rows from a table
Groups rows that have the same values into summary rows
Inserts new rows into a table
Restricts the number of rows returned by a query
What is the purpose of the SQL keyword SELECT?
Deletes data from a database
Retrieves data from a database
Inserts data into a database
Updates data in a database
Which SQL function is used to find the maximum value in a column?
COUNT
SUM
MIN
MAX
What is the purpose of SQL LIMIT clause?
Deletes duplicate rows from a table
Groups rows that have the same values into summary rows
Inserts new rows into a table
Restricts the number of rows returned by a query
What is the purpose of the SQL keyword HAVING?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Applies a filter condition to groups of rows
Which SQL function is used to calculate the total number of rows in a table?
AVG
MAX
COUNT
SUM
What is the purpose of the SQL keyword LIKE?
Deletes records from a table
Updates existing records in a table
Inserts new records into a table
Performs pattern matching on a column value
What is the purpose of the SQL keyword BETWEEN?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Checks if a value is within a range
Which SQL function is used to find the total number of distinct values in a column?
AVG
MAX
COUNT DISTINCT
SUM
What is the purpose of the SQL keyword JOIN?
Deletes records from a table
Updates existing records in a table
Combines rows from two or more tables based on a related column between them
Retrieves data from a database
What is the purpose of the SQL keyword ORDER BY?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Applies a filter condition to groups of rows
Which SQL function is used to calculate the average value in a column?
MAX
SUM
MIN
AVG
What is the purpose of the SQL keyword GROUP BY?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Applies a filter condition to groups of rows
What is the purpose of the SQL keyword DISTINCT?
Deletes duplicate rows from a table
Groups rows that have the same values into summary rows
Inserts new rows into a table
Retrieves unique records from a result set
Which SQL function is used to find the minimum value in a column?
COUNT
SUM
MIN
MAX
What is the purpose of the SQL keyword WHERE?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Applies a filter condition to groups of rows
What is the purpose of the SQL keyword WHERE?
Filters records based on conditions
Sorts the result set in ascending or descending order
Groups records based on a column
Joins two or more tables based on a related column
Which SQL function is used to find the total number of rows in a table?
AVG
MAX
COUNT
SUM
What is the purpose of the SQL keyword DISTINCT?
Deletes duplicate rows from a table
Groups rows that have the same values into summary rows
Inserts new rows into a table
Retrieves unique records from a result set
What is the purpose of the SQL keyword UPDATE?
Updates existing records in a table
Deletes records from a table
Inserts new records into a table
Retrieves data from a database
Which SQL function is used to calculate the average value in a column?
COUNT
MAX
MIN
AVG
What is the purpose of SQL DISTINCT keyword?
Filters records based on conditions
Sorts the result set in ascending or descending order
Selects unique records from a table
Groups records based on a column
