SQL quizz

What is missing in this code?

SELECT * FROM WHERE genre = 'action' ORDER BY year ARC;

• Table name

• Capitalize action

• Missing an AND

• None of these

Match the following SQL term with a description - ORDER BY

• The table used in the query

• The criteria that must be met

• The field and order used to sort the results

• The fields to display

When examining a row in a table, we refer to it as a...

• result

• result number

• row number

• record

How do we select all rows for the "Designer" table?

• SELECT Designer.*

• SELECT [All] FROM Designer

• SELECT FROM Designer

• SELECT * FROM Designer

What does the SQL term 'JOIN' refer to?

• Combining rows from two or more tables based on a related column between them

• Sorting the results in ascending order

• Filtering rows based on a condition

• Grouping rows with the same value

Which SQL statement is used to delete a table?

• REMOVE TABLE table_name;

• DROP TABLE table_name;

• DELETE TABLE table_name;

• ERASE TABLE table_name;

What is the purpose of the SQL statement 'GROUP BY'?

• To filter rows based on a condition

• To sort the results in descending order

• To group rows that have the same values into summary rows

• To update existing records in a table

If you were wanting to filter data, which clause would you use?

• Order by

• From

• Select

• Where

What does the SQL term 'HAVING' refer to?

• Filtering rows based on a condition

• Sorting the results in descending order

• Grouping rows with the same value

• Filtering groups based on a condition

Which SQL statement is used to update existing records in a table?

• MODIFY TABLE table_name;

• UPDATE TABLE table_name;

• CHANGE TABLE table_name;

• ALTER TABLE table_name;