AQA GCSE Computer Science 3.7 Relational databases and SQL overview quiz quiz

A single row describing one item

A single column holding one attribute

The name of the table

A link between two tables

A field that links one table across to another related table

A field that uniquely identifies each record

Always the very first field listed in a table

A password used to log in to the whole database

A field that uniquely identifies every record within its own single table

A secret key used to encrypt the data stored inside the database

A field in one table that holds the primary key of another table

Always the very last field that appears in a table

To make the database take up much more storage space on the disk

To deliberately slow down the queries that run against the database

Because SQL will only ever work correctly when there are exactly two tables

To avoid storing the same data many times and keep it consistent

WHERE

SELECT

FROM

ORDER BY

Only the very first field of each student record in the table

Every field of every record in the Students table

Only the students who happen to have a star rating

The total number of students in the table

WHERE

DISTINCT

ORDER BY

DELETE

SELECT

UPDATE

DELETE

INSERT

So that it only changes the intended records, not every record

To make the UPDATE statement run much faster against the table

Because an UPDATE statement simply cannot run at all without one

To sort all of the records into order before changing them

SELECT name FROM Members WHERE age > 18 ORDER BY age DESC LIMIT 18

SELECT name FROM Members WHERE age > 18 ORDER BY name

SELECT age FROM Members WHERE name > 18 ORDER BY name

INSERT name FROM Members WHERE age > 18 ORDER BY name

Without any marks around it at all, just the plain text

Inside square brackets, for example [Sam], around the value

In quotation marks, such as 'Sam'

Converted into a number before it is used