GCSE Computer Science: Databases & SQL Quiz

James E says a database is:

• A file

• A spreadsheet

• An organised collection of data

• A backup

Florry is asked to define a database. She says it stores...?

(a)  

Katie explains that a relational database:

• Has no structure

• Uses one big table

• Links data across multiple tables

• Is unstructured text

Jack says a table in a database is also called a...?

(a)  

Nathan explains a record in a table represents:

• A column

• A row

• A data type

• A field

Olivia is reviewing database structure. What is a field?

(a)  

Monty is asked about data types. Which of these is not a data type?

• INTEGER

• TEXT

• VARCHAR

• TABLE

Lucas says a primary key must be...?

(a)  

Zac explains that a foreign key is:

• Always unique

• A link to a primary key in another table

• A password

• A type of query

Robson says relational databases help reduce data...?

(a)