Database Concepts Quiz

Which of the following defines the term 'field' in relation to databases?

• A field is all of the information about one person or one thing

• A field is the collection of all the database records on one topic or subject

• A field is one type or piece of information

What does a table in a database contain?

• Only numbers

• Only images

• Rows (records) and columns (fields)

Which data type would store 'Monday, 12 June 2023'?

• Boolean

• Number

• Date/Time

What is meant by the term 'data integrity'?

• How colourful your data is

• Accuracy and consistency of data

• File size

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

Which file format is typically used to export databases?

• .jpg

• .doc

• .csv

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 a flat file database?

• A database with multiple linked tables

• A spreadsheet with a single table

• A paper-based storage file

Which of the following uses paper-based databases?

• Phonebook

• Smart Phone

• Computer

What happens if you store text in a number field?

• The system accepts it

• An error may occur or it will be rejected

• It converts to Boolean