S3 SQL STATEMENT INTERPRETATION

What is the purpose of the SELECT statement in SQL?

• To delete records from a table

• To insert new records into a table

• To retrieve data from a table

• To update records in a table

What will the following SQL statement do?

SELECT * FROM Customers WHERE City = 'Edinburgh';

• Retrieve all records from the Customers table

• Retrieve all records where the City is Edinburgh

• Retrieve only the City column from the Customers table

• Retrieve and delete all records where the City is Edinburgh

What SQL statement is used to add a new record to a table?

• INSERT INTO

• ADD RECORD

• NEW RECORD

• UPDATE

What will the following SQL statement do?

INSERT INTO Students (StudentID, Name, Age)
VALUES (101, 'Alice', 17);

• Add a new student named Alice to the Students table

• Update Alice's age to 17

• Delete Alice from the Students table

• Create a new table called Students

What is the correct SQL statement to change a customer's phone number?

• CHANGE Customers SET Phone = '123456789' WHERE Name = 'John';

• UPDATE Customers SET Phone = '123456789' WHERE Name = 'John';

• MODIFY Customers SET Phone = '123456789' WHERE Name = 'John';

• INSERT INTO Customers (Phone) VALUES (123456789);

What will the following SQL statement do?

DELETE FROM Orders WHERE OrderID = 10;

• Remove the Orders table from the database

• Remove all orders from the database

• Remove the order with OrderID 10

• Remove the column OrderID from the Orders table

What does the ORDER BY clause do in SQL?

• Filters records based on a condition

• Sorts records in order

• Updates multiple records in a table

• Selects records based on a condition

What will the following SQL statement do?

SELECT * FROM Products ORDER BY Price DESC;

• Show all products sorted from lowest to highest price

• Show all products sorted from highest to lowest price

• Show only the Price column from the Products table

• Show products over a certain value

What is the purpose of an Equi-Join in SQL?

• To delete records from multiple tables

• To retrieve records from multiple tables where a common column matches

• To update a column with a calculated value

• To remove duplicate records

Write an SQL SELECT statement to retrieve the Title and ReleaseYear of all films in the Films table that belong to the Sci-Fi genre.