SQL Basics Quiz

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