What are databases primarily used for?
To store archived data
To stored organised data
To analyse data
What is an advantage of a flat-file database?
It is a very compatible way of storing data
All the data is in the same place
All the data is stored in separate tables that are linked together
What is data mining?
Analysing large amounts of data to predict future events and trends
A description of any data that is freely available
A description of data that is shared
What is open data?
Open data is data that only certain people have access to
Open data is data that is freely available and shared
Open data is data that is very secure
What is the difference between an entity and an attribute?
An attribute is a table in a database and an entity is a field
An attribute is a record in a database and an entity is a table
An attribute is a field in a database and an entity is a table
Why would you create a primary key?
To make each record in a database unique
To make each field in a database unique
To make each query in a database unique
What is the difference between verification and validation?
Validation checks that the data you have entered matches the data you were given to enter. Verification checks that all the rules applied to that data are met
Validation checks that the correct type of data is entered, whereas verification checks that the data is actually the data you want
Verification checks that the correct type of data is entered, whereas validation checks that the data is actually the data you want
What is data integrity?
Data integrity is how effective the interface of the database is
Data integrity relates to how large the database is
Data integrity relates to how accurate and consistent data is
Which of the following are types of validation?
Length check, type check, range check, presence check
Length check, type check, sound check, data check
Length check, size check, range check, data check
What is data typing?
A way of classifying data values that have common properties
A way of identifying if data is unique or not
A way of carrying out verification on data