4. Databases and Data Management

Sql Basics — Quiz

Test your understanding of sql basics with 5 practice questions.

Practice Questions

Question 1

Which SQL keyword is used to remove a table from a database?

Question 2

What will the following SQL query return: SELECT COUNT(*) FROM orders WHERE total > 100; if the 'orders' table has 200 rows and 150 of those rows have 'total' values greater than 100?

Question 3

What does the following SQL query do: UPDATE employees SET department = 'HR' WHERE department = 'Human Resources'; ?

Question 4

Which of the following queries returns the highest 'price' from the 'products' table?

Question 5

What does the following SQL query do: SELECT customer_id, COUNT(order_id) FROM orders GROUP BY customer_id; ?