SQL Quiz

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