Font size
WorksheetsAQA GCSE Databases and SQL
Total questions: 14
Worksheet time: 13mins
What is a Primary Key?
A unique field within a table that ensures all records are unique
A field that appears in multiple tables in order to join them together
A unique field that is used to link together all the records in a table
A common field that all tables include
(a) firstName, lastName, age (b) Students
(c) yearGroup = "11"
Select the correct command to join two tables togehter
WHERE Student.ID = Exam.ID
WHERE Student.ID != Exam.ID
WHERE Student = Exam
WHERE Student.ID IS Exam.ID
SQL Stands for
Structured Query Language
Static Query Language
Structured Question Language
Sample Query Language
Structure Question Language
Label The Primary and Foreign Keys
Primary Key
Foreign Key
What does the Orange represent on the following image?
A Field
A Record
What does the Blue represent on the following image?
A Field
A Record
Click on all the fields that would be returned by the following statement:
SELECT FirstName, LastName, DatePresented FROM Member, Award
The field that joins two tables together is the (a) key
State two benefits of using relational databases
Reduces data redundancy
Less information to read
Reduces data inconsistency
Faster at retrieving information
Can store more information
INSERT INTO (a)
(b) (5, 'Alina', 'Ahmed', '2020-11-30')
What is the difference between a relational and a flat file database?
Select the correct query from the list below
DELETE FROM Customers
WHERE name = "Mr Reid";
DELETE * FROM Customers
WHERE name = "Mr Reid"
DELETE name FROM Customers
WHERE name = "Mr Reid"
Reorder the following
SELECT FirstName, LastName, OrderDate, OrderNumber
FROM Customers, Orders
WHERE Customers.CustomerID = Orders.CustomerID
AND OrderDate = "Jan 2025"
ORDER BY OrderNumber ASC
