Database Quiz

What are databases primarily used for?

• To store archived data

• To store and organise 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?

• Analyzing 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