SQL SELECT Statement Quiz

What is the primary purpose of the SELECT statement in SQL?

• To delete data from a table

• To update data in a table

• To create a new table

• To retrieve data from a table

Which column in the 'earthquake' table uniquely identifies each row?

• occurred_on

• earthquake_id

• magnitude

• place

What does the asterisk (*) signify in a SELECT statement?

• Selects no columns

• Selects all columns

• Selects only text columns

• Selects only numeric columns

How can you count the number of rows in a table using SQL?

• Using the COUNT function

• Using the AVG function

• Using the SUM function

• Using the MAX function

Which SQL clause is used to filter rows based on a condition?

• ORDER BY

• HAVING

• GROUP BY

• WHERE

What is the purpose of the ORDER BY clause in SQL?

• To group rows

• To join tables

• To sort rows

• To filter rows

How can you sort data in descending order using SQL?

• Using the DESC keyword

• Using the DOWN keyword

• Using the SORT keyword

• Using the ASC keyword

What does the LIMIT keyword do in a SQL query?

• Limits the number of rows returned

• Limits the number of columns

• Limits the number of tables

• Limits the size of the database

Which part of a SQL query specifies the table to retrieve data from?

• ORDER BY

• WHERE

• FROM

• SELECT

What is the correct order of clauses in a typical SQL SELECT query?

• SELECT, WHERE, FROM, ORDER BY

• WHERE, SELECT, FROM, ORDER BY

• FROM, SELECT, WHERE, ORDER BY

• SELECT, FROM, WHERE, ORDER BY