IGCSE Databases

A structured collection of data on a computer system is called a...

• website

• database

• program

• file

The object about which data is being stored is called the...

• file

• field

• entity

• data

A __ is an every single row in a database which stores data about a new instance of an entity

What is the definition of a Primary Key?

• The first field in a database table

• A field in a table that contains a unique identifier for each record in the table

• A field in a database that can only contain two values

• A field in the database that has the same value for each record

What is the definition of a Foreign Key?

• A field in a table that is written in another language

• A field in a table that links to the World Wide Web

• A field in a table that cannot be edited or accessed by users

• A field in a table that is used as a link to a field in another table

What is a flat-file database?

• A paper version of a database

• A compressed database

• A database consisting of one table only

• A database consisting of text only

How would you define a relational database?

• A database consisting of data relating to families

• An online database

• A database linked to another database

• A database consisting of multiple tables, that are linked using keys

What type of field would be best to store the following text: "11-00-67"

• Number

• Currency

• Date

• Text

What is the definition of a database entity?

• Another name for a table

• A way of performing searches and sorts in a database

• It represents people, places, objects or things stored in tables in a database

• A way of linking tables in a database

A column in a database.

• Field
• Record
• Entity
• Validation