OCR Alevel - Database key terms

Which is the best description of a database?

• Stores data

• Stores data in a organised structure

• Stores data in an organised and logical structure

A collection of fields and records in a specific category

• Record

• Table

• Field

• Primary key

Rows in a database tables are called...

• Fields

• Records

• Tables

• Entities

Columns in a database are called...

• Rows

• Fields

• Tables

• Tuple

All data related to one item in a table is a ...

• Record

• Field

• Table

• Primary key

Which of the following is an example of a record?

• 347

• ChannelType

• 351, Nature, Documentary, Bling, False

• ChannelID

Which of the following is an example of a field?

• TimesPlayed

• 004

• Holidays

• 005

Which of the following would be used to uniquely identify a record

• Field size

• Validation

• Data type

• Primary Key

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