WorksheetsSQL Basics Quiz
Total questions: 1
Worksheet time: 10mins
1-10.
Answer the questions below after watching the video
What is a database used for?
To process data quickly
To display data visually
To store a large amount of information
To store a small amount of information
Which three words are essential for basic SQL queries?
SELECT, FROM, WHERE
INSERT, DELETE, UPDATE
JOIN, GROUP BY, ORDER BY
CREATE, DROP, ALTER
What does the 'SELECT' keyword do in SQL?
It updates data in a table
It inserts data into a table
It retrieves data from a table
It deletes data from a table
How would you retrieve the names of cheeses priced over two pounds?
SELECT name FROM cheese_table WHERE price > 2
SELECT price FROM cheese_table WHERE name > 2
SELECT name FROM cheese_table WHERE price < 2
SELECT * FROM cheese_table WHERE price > 2
What result would you get from the query: SELECT name, color FROM cheese_table WHERE strength = 2?
Mild Cheddar, Orange
Edam, Yellow
Mature Cheddar, Yellow
Stilton, White
Which Boolean operator would you use to combine conditions in SQL?
AND
OR
NOT
BOTH
What would be the result of the query: SELECT name, color FROM cheese_table WHERE strength > 1 AND color = 'yellow'?
Mild Cheddar, Orange
Mature Cheddar, Yellow
Stilton, White
Edam, Yellow
What does the asterisk (*) symbol represent in SQL?
It inserts all rows into a table
It updates all rows in a table
It deletes all rows from a table
It selects all columns from a table
How would you retrieve all rows where the name starts with 'M'?
SELECT * FROM cheese_table WHERE name = 'M%'
SELECT * FROM cheese_table WHERE name LIKE 'M%'
SELECT * FROM cheese_table WHERE name LIKE '%M'
SELECT * FROM cheese_table WHERE name = 'M'
What is the purpose of the LIKE operator in SQL?
To delete rows based on a pattern
To update rows based on a pattern
To select rows based on a pattern
To insert rows based on a pattern
