3. Databases

Sql Basics — Quiz

Test your understanding of sql basics with 5 practice questions.

Practice Questions

Question 1

Which of the following SQL queries retrieves all rows from a table named Customers where the City is 'New York' and the Age is greater than 30?

Question 2

Which SQL query will update the phone number to '555-1234' for all customers in the Customers table who live in 'Chicago'?

Question 3

What will the following SQL query return? $$ \text{SELECT FirstName, LastName FROM Employees WHERE DepartmentID = 5;} $$

Question 4

Which SQL query will insert a new row into the Products table with a ProductID of 101, a ProductName of 'Laptop', and a Price of 999.99?

Question 5

Which of the following SQL queries will correctly return the total number of employees in each department from the Employees table, grouped by DepartmentID?