(d) SQL – Interpret and modify.

Question 1

What does SELECT * FROM Customers; do?

Answer 1

Retrieves all columns and rows from the Customers table.

Question 2

Write an SQL query to find customers in ‘London’.

Answer 2

SELECT * FROM Customers WHERE City = ‘London’;

Question 3

What does UPDATE do in SQL?

Answer 3

Modifies existing data in a table.

Question 4

What does DELETE FROM Orders WHERE OrderID = 101; do?

Answer 4

Deletes the order with OrderID 101 from the Orders table.

Question 5

What does JOIN do in SQL?

Answer 5

Combines rows from two or more tables based on a related column.