Which of the following is a piece of software used to create databases?
Respuesta
Google Chrome
Microsoft Office PowerPoint
Microsoft Office Access
Pregunta 3
Pregunta
What term describes a personalised letter which can be sent to customers of a supermarket?
Respuesta
Report
Mail merge
Macro
Pregunta 4
Pregunta
Which of the following is an advantage to paper-based databases?
Respuesta
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.
Pregunta 5
Pregunta
Thinking of data, information and knowledge - which of the following is an example of information?
Respuesta
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.
Pregunta 6
Pregunta
Which of the following holds a single piece of data?
Respuesta
Table
Record
Field
Pregunta 7
Pregunta
Which field would be inappropriate in a database of countries?
Respuesta
Continent
Population
First Name
Pregunta 8
Pregunta
What is the correct definition of primary key?
Respuesta
The first field in a table.
A field that contains unique data in each record.
The field which we will use to search with.
Pregunta 9
Pregunta
What database feature checks to see if data meets certain rules when entered to a table?
Respuesta
Table
Query
Validation
Pregunta 10
Pregunta
Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?
Respuesta
List check
Presence check
Range check
Pregunta 11
Pregunta
What is a database record?
Respuesta
All of the records in a field
All the data about one item in the database.
the colour of a persons hair
Pregunta 12
Pregunta
What is data redundancy?
Respuesta
The unnecessary repetition of data.
The removal of data.
inputting the wrong data.
Pregunta 13
Pregunta
What is data validation?
Respuesta
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.
Pregunta 14
Pregunta
What is data verification?
Respuesta
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.
Pregunta 15
Pregunta
What is a relational database?
Respuesta
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
Pregunta 16
Pregunta
How are tables linked together in a database?
Respuesta
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.