Levnt
Quiz by , created more than 1 year ago

GCSE Computer Science Quiz on Databases, created by Levnt on 05/23/2016.

5
0
0
Levnt
Created by Levnt about 10 years ago
Close

Databases

Question 1 of 10

1

What are databases primarily used for?

Select one of the following:

  • To store archived data

  • To stored organised data

  • To analyse data

Explanation

Question 2 of 10

1

What is an advantage of a flat-file database?

Select one of the following:

  • 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

Explanation

Question 3 of 10

1

What is data mining?

Select one of the following:

  • 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

Explanation

Question 4 of 10

1

What is open data?

Select one of the following:

  • 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

Explanation

Question 5 of 10

1

What is the difference between an entity and an attribute?

Select one of the following:

  • 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

Explanation

Question 6 of 10

1

Why would you create a primary key?

Select one of the following:

  • To make each record in a database unique

  • To make each field in a database unique

  • To make each query in a database unique

Explanation

Question 7 of 10

1

What is the difference between verification and validation?

Select one of the following:

  • 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

Explanation

Question 8 of 10

1

What is data integrity?

Select one of the following:

  • 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

Explanation

Question 9 of 10

1

Which of the following are types of validation?

Select one of the following:

  • Length check, type check, range check, presence check

  • Length check, type check, sound check, data check

  • Length check, size check, range check, data check

Explanation

Question 10 of 10

1

What is data typing?

Select one of the following:

  • 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

Explanation