WorksheetsSQL quizz
Total questions: 13
Worksheet time: 85secs
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;
What is the purpose of the SQL statement 'DISTINCT'?
To filter rows based on a condition
To remove duplicate rows from the result set
To group rows that have the same values into summary rows
To update existing records in a table
When examining a column in a table, we refer to it as a...
folder name
field name
column name
table name
What does "SQL" stand for?
Simple Question Language
Structured Question Language
Structured Query Language
Simple Query Language
