Databases

What is a database?

• A piece of software to do calculations
• A device to load information onto the computer.
• A structured collection of information
• A calculator

Which of the following describes a relational database?

• Access
• A database that has a table
• There are two or more tables that are linked using the primary keys
• There are more than one table that have duplicate data

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 Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?

• Add another field
• Amend a record
• Add a new record
• Delete a record

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 scout company have a database with records of all the scouts.  They want to create a list of all scouts who are under 15 and their achievements. What would they use? 

• SQL UPDATE command
• Form 
• SQL SELECT Query
• Sort

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

A health club wants to find all the members who use the club 3 days or more a week.  What will they put in the query in the 'days' SQL query criteria?

• >3
• <3
• <=3
• >=3