S3: DATABASES UP TO EQUI JOIN

Which SQL clause is used to specify the condition for joining tables in the query?

• SELECT

• FROM

• WHERE

• JOIN

What is the role of the '=' operator in an Equi-Join?

• To subtract values

• To compare values for equality

• To multiply values

• To divide values

What does the following SQL statement do?

SELECT name, age FROM Students;

• Displays all fields in the Students table.

• Displays the name and age fields from the Students table.

• Deletes the name and age fields in the Students table.

• Creates a new table with name and age fields.

What does the following query do?

SELECT * FROM Teachers WHERE subject = 'Maths';

• Displays all teachers except those who teach Maths.

• Updates the subject field for teachers to 'Maths'.

• Displays all fields for teachers who teach Maths.

• Deletes teachers who do not teach Maths.

Which of the following is the correct syntax to add a new student with a name of "Alice" and an age of 15 to the Students table?

• ADD INTO Students VALUES ("Alice", 15);

• INSERT INTO Students VALUES ("Alice", 15);

• INSERT INTO Students (name, age) VALUES ("Alice", 15);

• INSERT name = "Alice", age = 15 INTO Students;

Which SQL query updates the price of a product in the Products table to 9.99 for a product with the productID of 101?

• UPDATE price SET Products = 9.99 WHERE productID = 101;

• UPDATE Products SET price = 9.99 WHERE productID = 101;

• CHANGE price TO 9.99 WHERE productID = 101 IN Products;

• SET price = 9.99 IN Products WHERE productID = 101;

What is the purpose of the following SQL query?
DELETE FROM Orders WHERE orderID = 123;

• Removes the Orders table from the database.

• Deletes all orders except the one with orderID 123.

• Deletes the order with orderID 123 from the Orders table.

• Deletes the orderID field from the Orders table.

Which SQL statement retrieves all matching records from the Customers and Orders tables where the customerID matches in both?

• SELECT * FROM Customers, Orders INNER JOIN Orders ON customerID = orderID;

• SELECT * FROM Customers, Orders INNER JOIN Orders WHERE Customers.customerID = Orders.customerID;

• SELECT * FROM Customers, Orders WHERE Customers.customerID = Orders.customerID;

• SELECT * FROM Customers JOIN Orders WHERE customerID = orderID;

What does Orders.orderDate refer to in the following query?
SELECT Orders.orderDate FROM Orders;

• All the fields in the Orders table.

• A specific record in the Orders table.

• The name of a new table called Orders.orderDate.

• The orderDate field in the Orders table.

What does this query do?
SELECT * FROM Employees ORDER BY salary ASC;

• Displays all employee fields and records sorted by highest to lowest salary

• Displays all employee fields and records alphabetically.

• Displays all employee fields and records sorted by lowest to highest salary

• Displays all employee fields and records grouped by salary.