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

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

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

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

• Ascending order
• Descending order

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

• Field size

• Validation

• Data type

• Primary Key

To find a particular set of data in a database you would use a:

• Table

• Form

• Query

• Report