Databases

Description

GCSE Computer Science Quiz on Databases, created by Levnt on 05/23/2016.
Levnt
Quiz by Levnt, updated more than 1 year ago
Levnt
Created by Levnt about 10 years ago
5
0

Resource summary

Question 1

Question
What are databases primarily used for?
Answer
  • To store archived data
  • To stored organised data
  • To analyse data

Question 2

Question
What is an advantage of a flat-file database?
Answer
  • 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

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
  • A way of identifying if data is unique or not
  • A way of carrying out verification on data
Show full summary Hide full summary

Similar

Computing Hardware - CPU and Memory
ollietablet123
SFDC App Builder 2
Parker Webb-Mitchell
Data Types
Jacob Sedore
Intake7 BIM L1
Stanley Chia
Software Processes
Nurul Aiman Abdu
Design Patterns
Erica Solum
CCNA Answers – CCNA Exam
Abdul Demir
Abstraction
Shannon Anderson-Rush
Spyware
Sam2
HTTPS explained with Carrier Pigeons
Shannon Anderson-Rush
FLAT FILE VS RELATIONAL DATABASE
rosiejones