SQL

Question 1

What does SQL stand for?

Answer 1

Structured Query Language.

Question 2

Which function is used to fetch an item from a database?

Answer 2

SELECT

Question 3

Which function is used to insert data into a database?

Answer 3

INSERT

Question 4

Which function is used to edit/modify existing data in a database?

Answer 4

UPDATE

Question 5

Which function is used to delete data from a database?

Answer 5

DELETE

Question 6

Which function is used to create a new data table?

Answer 6

CREATE TABLE

Question 7

Which function is used to delete a data table?

Answer 7

DROP

Question 8

(a) Using SQL write a command to fetch a CustomerID from Customers, where the BookingDate is 12/7/22 in Bookings.
(b) Sort these into descending order.

Answer 8

SELECT BookingID FROM Bookings
WHERE SELECT CustomerID = (SELECT CustomerID FROM Bookings WHERE BookingDate = “12/7/22”)
ORDER BY CustomerID DESC

Question 9

Using SQL write a command to insert new values into a table called ‘Students’.

Answer 9

INSERT INTO Students
(StudentID, StudentName, DOB, Gender, Postcode)
VALUES
(“ST9”, “Adam”, “29/01/2001”, “M”, “OX69TG”)