DATBASE THEORY TEST

A sports club needs to store information about each member.  The individual information about each member is called a:

• Field
• File
• Table
• Record

One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?

• Amend the record
• Delete the field
• Delete the record
• Delete the file

The whole database is called:

• The file
• The field
• The record
• The table

One specific piece of information about a person or thing is called:

• Field
• File
• Record
• Table

A gym has a database with all their members they want to include email addresses in the database, what will they do?

• Add a record
• Add a field
• Edit a record
• Delete a field

The school wants to sort the data by staff Surname.  How will they sort it?

• Ascending order
• Descending order

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

In a database about school form groups, you would need to create a different _____ for each year group

• Table

• Record

• Field

Rows in a database tables are called...

• Fields

• Records

• Tables