Databases Theory 2 - Intro 2 Query ALB

True or False: A database is a collection of data or information in a table, which is stored in a logical and structured way.

• True

• False

What run from left to right and are identified by numbers?

• Rows

• Column

• Horizontal

• Files

Which of these is not an advantage of a Paper-based database?

• Don’t need training to learn how to use them.

• Can carry them around with you.

• Don’t need a computer – which is expensive.

• Needs electricity, so will not work if you have a power cut.

Which of these is not a disadvantage of a Paper-based database?

• Can take a while to search for a particular record.

• Can't be lost

• Hard to update or make changes.

• Card systems can get in a muddle if cards not replaced in the correct order.

Which of these is not a disadvantage of a Paper-based database?

• Can import or export data to/from other packages.

• Can search for particular records very quickly.

• Can not easily make changes.

• Can easily sort data into order e.g. alphabetic.

The school keeps a lot of data/information about you, workers & staff, which of these is not kept?

• Your names/parents names

• Your address/ DOB

• Doctor's name/allergies/illnesses

• Number of school your uniforms/PE kits/blazers

In this diagram, what is the red column border area called?

• Feild

• Field

• Force

• Flield

In this diagram, what is the purple border row area called?

• Row

• Record

• Horizontal Row

• Read

All of the ‘records’ are stored together as a ?

• Table

• File

• Storage

• Record

A query can be used to replace sort/filter function?

• False

• True