All the data is stored in separate tables that are linked together
Question 3
Question
What is data mining?
Answer
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
Question 4
Question
What is open data?
Answer
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
Question 5
Question
What is the difference between an entity and an attribute?
Answer
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
Question 6
Question
Why would you create a primary key?
Answer
To make each record in a database unique
To make each field in a database unique
To make each query in a database unique
Question 7
Question
What is the difference between verification and validation?
Answer
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
Question 8
Question
What is data integrity?
Answer
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
Question 9
Question
Which of the following are types of validation?
Answer
Length check, type check, range check, presence check
Length check, type check, sound check, data check
Length check, size check, range check, data check
Question 10
Question
What is data typing?
Answer
A way of classifying data values that have common properties