Which of the following is NOT true of databases?
You can store large amounts of data.
You have to use a computer.
You can search the data.
Which of the following is a piece of software used to create databases?
Google Chrome
Microsoft Office PowerPoint
Microsoft Office Access
What term describes a personalised letter which can be sent to customers of a supermarket?
Report
Mail merge
Macro
Which of the following is an advantage to paper-based databases?
It is easy to add or amend records.
You do not need any training on how to use the database.
Data can be sorted and re-sorted easily.
Thinking of data, information and knowledge - which of the following is an example of information?
The average men's shoe size is nine.
9
If you are to open a shoe shop, you must stock plenty of size nine shoes.
Which of the following holds a single piece of data?
Table
Record
Field
Which field would be inappropriate in a database of countries?
Continent
Population
First Name
What is the correct definition of primary key?
The first field in a table.
A field that contains unique data in each record.
The field which we will use to search with.
What database feature checks to see if data meets certain rules when entered to a table?
Query
Validation
Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?
List check
Presence check
Range check
What is a database record?
All of the records in a field
All the data about one item in the database.
the colour of a persons hair
What is data redundancy?
The unnecessary repetition of data.
The removal of data.
inputting the wrong data.
What is data validation?
Checking if the data is from a reliable source.
The process of checking data as it is entered into the system to ensure it is entered correctly.
Checking if the data interesting.
What is data verification?
Updating records.
The checking that the data is true or correct (usually by human checking).
Checking to see if the data has already on the system.
What is a relational database?
A relationship database stores data in tables. Each table contains data about one entity. Each table is called a relation. Tables are linked together using keys.
A database that stores information about relatives.
A database about a specific subject
How are tables linked together in a database?
The tables are typed in to the database and added together to make one table.
A database will automatically use all the tables available.
Tables are linked together by using keys. The primary key in one table is linked to another table as a foreign key.
