SQL SELECT Queries Quiz

What is the primary purpose of a SELECT query in SQL?

• To update data in a table

• To insert data into a table

• To delete data from a table

• To retrieve data from one or more tables

What is the significance of using the ORDER BY clause in a SQL query?

• To filter data based on conditions

• To group data into categories

• To limit the number of rows returned

• To sort the data returned by the query

Which SQL clause is used to limit the number of rows returned by a query?

• ORDER BY

• LIMIT

• WHERE

• GROUP BY

What SQL function would you use to find the total number of rows in a table?

• MAX

• MIN

• COUNT

• SUM

Which SQL function would you use to find the smallest value in a column?

• AVG

• MAX

• MIN

• SUM

How can you ensure that a SQL query returns only unique rows?

• Use the EXCLUSIVE keyword

• Use the DISTINCT keyword

• Use the DISTINCTIVE keyword

• Use the UNIQUE keyword

What is the correct SQL clause to find the most recent event in a dataset?

• LIMIT 1

• GROUP BY column_name

• ORDER BY column_name DESC

• ORDER BY column_name ASC

Which SQL operator would you use to find rows with a specific pattern in a column?

• LIKE

• BETWEEN

• IN

• MATCH

What is the purpose of the BETWEEN operator in SQL?

• To find rows with values in a list

• To find rows with values matching a pattern

• To find rows with values within a specific range

• To find rows with values greater than a specific value

How can SQL be used in real-world applications related to natural disasters?

• To build early warning systems

• To predict the exact time of future earthquakes

• To prevent earthquakes from occurring

• To create new earthquakes