A database is a way of storing information in an organised, logical way. It's important to know when to use a database and be aware of its advantages.
What should a database always contain?
Loads of records
A key field
Where is data stored?
What is a database in which ALL the data is stored in a single table known as?
Flat file database
What is a database with multiple tables which are linked together known as?
What is a data capture form specifically designed to collect?
What is a database accessible by many users on different computers known as?
Easily accessible database
Which of the following queries would find all animals that are dogs and 10 yrs or older?
[animal]=dog OR [age] >10
[animal] =dog AND [age] >10
[animal] =dog AND [age] >=10
Which of the following queries would find all Jaguar cars costing over £10,000?
[make]=Jaguar AND [price] >10,000
[make]=Jaguar AND [price] >=10,000
[make]=Jaguar OR [price] >10,000
Which of these is NOT an advantage of relational databases?
Details need only be entered once
Duplication is avoided
Data is stored in one table
Which of these is NOT an advantage of using 'Y' and 'N' for 'yes' and 'no' in a database?
It is quicker to type
It uses less disk space
It requires more complex validation