Font size
WorksheetsY9 U3 Database - Intro
Total questions: 54
Worksheet time: 26mins
What are numbers, pictures or words without context known as?
Data
Information
Knowledge
What are a collection of words, numbers or pictures with meaning known as?
Data
Information
Knowledge
What does putting data into a framework or structure provide?
More information
Rules
Context
The statement 'it was raining outside' is which of these?
Data
Information
Knowledge
What are databases mainly used for?
To store archived data
To store and organise data
To analyse data
Which of these holds lots of data?
Record
Field
Table
Drawing
In a TABLE, a column is known as a...
Record
Field
Row
Data
In a TABLE, a row is known as a...
Information
Column
Data
Record
The best data type to choose for a memberID would be
Number
Date/Time
Text
Currency
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
The software that we use to create a database is
Microsoft Publisher
Microsoft Word
Microsoft Excel
Microsoft Access
In a database, data is stored in
Queries
Forms
Reports
Tables
In a database, all the information about one person or thing is called a
Worksheet
Presentation
Record
File
What is a the definition of a database?
A collection of information or data that is stored in a logical or structured way.
A collection of information or data
Data stored alphabetically
Data stored on a computer
what is a record?
A complete row of data
All the data about one person or thing
A column of data
A table of data
What is a field?
Different categories within each record
A column
A row
A Table
What is a database File?
The whole database
A Field
A Column
A row
All the records are stored in what?
A Field
A Row
A column
A Table
Which of these are examples of a paper-based database?
Yellow pages
Personal book of Telephone numbers
A Christmas Card list of names and addresses
Which of these is an advantage of paper based databases
Can search for particular records very quickly
Can easily sort into order
Can easily make back up copies
Little to no training needed
Which of these is an disadvantage of paper based databases
Can search for particular records very quickly
Can easily sort into order
Can easily make back up copies
Files are easy to lose
Which of these is an advantage of computerised databases
Can search for particular records very quickly
Cheap
Very little training needed
Which of these is an disadvantage of computerised databases
Expensive
Lots of space is needed
Not easy to make copies of files
Files are easy to lose
Tables in databases are designed to:
to store database data
for the selection and processing of database data
to enter database data and view them
to automatically execute a group of commands
A field or set of fields with values that are unique throughout a table.
primary key
foreign key
database
record
What does a Boolean field store?
Numbers
Dates
True or False
Any data, with the database automatically choosing the appropriate data type.
What type of data stored in the Name field?
Date and time
Numeric
text
yes/no
What type of data is stored in the shoe size field?
Numeric
yes/no
alphanumeric
text
what data type is stored in Sports field?
text
numeric
yes/no
alphanumeric
What type of data is stored in Hair Colour field?
yes/no
alphanumeric
Data / time
text
This type of data can only have two values: TRUE or FALSE and YES or NO?
Alphanumeric/text
Logical Boolean
Date/Time
Numeric
This data type refers to data made up to letters and numbers symbols and spaces?
Numeric
Date and time
Alphanumeric/text
Currency
This type of data can store two types of numbers a whole numbers and a decimal numbers?
Alphanumeric
Numeric
Currency
Logical Boolean
This data types stores data in a date or time format?
Alphanumeric
Logical Boolean
Numeric
Date/time
This type of data stores money values in the database?
Numeric
Currency
Alphanumeric
Numbers
Which of these are examples of database fields? (tick all that apply)
1st
Age
Mr
Class
How many records can you see in this database?
6
30
5
15
We want to answer the question: 'How long is the longest dinosaur?' Which field would you use to answer it?
Name
Diet
Length
12
Which field has this data been sorted by?
Surname
Class
Boarded
Age
Which two fields have been used to create this graph?
Population and Country Name
Country Name and Area
Area and Currency
Currency and Population
Name the part of this database.
(a)
Name the part of this database.
(a)
Name the part of this database.
(a)
Name the type of field used to hold unique data that is used to identify each record.
(a)
Name THREE main data types used in database fields.
Which data type would be most suitable for the 'DateofBirth' field?
Currency
Number
Date/Time
Yes/No
How many Fields are there in this database?
6 Fields
3 Fields
5 Fields
2 Fields
How many records are there in this database?
1 record
5 records
7 records
9 records
Give a name of a field that contains Numeric Integer Data
Genre
Title
Rating
Product Id Number
