WorksheetsYr8 Databases
Total questions: 80
Worksheet time: 40mins
What is a database?
Can be used to create video clips
Made of cells, uses formulas to make automatic calculations
A place where we store large amount of data in a structured format
Used to edit graphical images
What is the correct definition for a field and a record?
Fields are made of green grass and records contain music
Fields are where you put data, records are where you sort data
Fields are single pieces of information and records are a collection of data about a single person or item
Fields are rows, records are columns
What is a relational database?
A database that you use to carry out financial calculations
A database with one table
A database that has links to other programs
A database with more than 1 table that link together through key fields
What is a database called that has only one table?
Flat file database
Single Table Database
Relational Database
One file database
Which type of database is this?
Flat File
Relational
Which type of relationship does the crime table have to the suspect table?
One-to-One
One-to-Many
Many-to-Many
Which of these is an advantage of using relational databases?
All records are stored in one place
Less Secure
Data is only stored once but can be used in multiple tables
Easy to understand
What is database maintenance?
When you sort data in a database table
Tasks that are used to improve the running of a database
Searching information in a database
A printout of data
Identify the correct datatypes used in Microsoft Access
Text, Number, Graph, Picture
Text, Boolean, HTML, Integer
Image, Video, Audio, Text
Text, Number, Date/Time, Currency
What would be the correct data type for the field 'Date of Birth'?
Date
Date/Time
Auto Number
Text
Which data type would you apply to information stored about a company's finances (income & expenditure)?
Currency
Text
Date/Time
Number
What is data validation?
Importing data into a table
Rules used to reduce errors when data is entered
A method of sorting data
A different method of entering data into a table
Which of these is NOT a validation rule?
Spell check
List check
Input Mask
Field Length
What does GIGO stand for?
Get in Green Oranges
Good Input, Good Output
Graphical Interface Give Outputs
Garbage in Garbage Out
When we want to search a database for specific data - we use a....?
Macro
Report
Sort
Query
What results will this query show?
All females over 1.7m tall that wear glasses
All males with brown hair, over 35 with an eye patch
All females with brown hair, blue eye and over 1.5m tall
All males over 1.7m tall that have an eye patch and blood type 'O'
Which are the Boolean operators for less than, greater than and equal to?
()=
<>=
\/=
{}=
Reports are used to....?
Search data
Sort data in to order
Input data in to a table
Output data from a query or table
Why are reports a good way to output data?
You can search data using criteria
They just look nice!
You can sort data into alphabetical order
You can display specific data neatly and ready to print
What is the definition of a Primary Key?
A field in a table that contains a unique identifier for each record in the table
A field in the database that has the same value for each record
A field in a database that can only contain two values
The first field in a database table
What is the definition of a Foreign Key?
A field in a table that is written in another language
A field in a table that to the World Wide Web
A field in a table that cannot be edited or accessed by users
A field in a table that is used as a link to a field in another table
What is a flat-file database?
A database consisting of text only
A database consisting of one table only
A paper version of a database
A compressed Database
How would you define a relational database?
A database consisting of data relating to families
An online database
A database linked to another database
A database consisting of multiple tables, that are linked using keys
What type of field would be best to store the following text: "11-00-67"
Date
Number
Text
Currency
What does a Boolean field store?
True or False
Numbers
Dates
Any date, with the database automatically choosing the appropriate data type
What can a number field be used to store?
All numeric values
Formulas
Whole numbers only
Calculations
Which Act of Parliament ensures the prior consent of users before storing personal information?
Copyright, Designs and Patents Act
Computer Misuse Act
Fraud Act
Data Protection Act
What is the definition of a database entity?
A way of linking tables in a database
Another name for a table
A way of performing searches and sorts in a database
It represents people, places, objects or things stores in tables in a database
What is the definition of an database attribute?
An attribute is a characteristic of an entity and will become a field during implementation
An attribute in another term for a table
An attribute is another term for field type
A form of validation that can be used in a database
What is a data dictionary used for?
To provide descriptions of the data held in a database and to act as a reference when creating a database system
To define the relationships between different tables
To define the language and definition of words and terms used in database development
To define the meaning of data types
What is a presence check?
A check used to ensure that every table has data entered
A check used to make sure that database images appear in reports as they should
A check used to ensure that a field is not left blank
A check use to make sure that a database has been created
Which validation rule is applied when the data in a particular field can only be from a preset list of values?
Restricted Choice
Presence Check
Range Check
Length Check
0 or > 100 will find numbers
Between 0 and 100 only
Number less than 99
0 or greater than 100
Numbers greater than 100
Which type of relationship best describes the following?
Head Teacher who runs a School
One to Many
Many to Many
One to One
Which of these is a one to many relationship?
All of the above
Mum and Children
Customer and order
Printer model and cartridge
Which of the following is not a computerised database?
Airline Booking System
Telephone Directory
Bank Account Records
Government Records
A field containing a unique value is known as?
Prime Key
Unique Key
First Key
Primary Key
Which is the best description of a database?
Stores data
Stores data in a organised structure
Stores data in an organised and logical structure
A collection of fields and records in a specific category
Record
Table
Field
In a database about school form groups, you would need to create a different _____ for each year group
Table
Record
Field
All data related to one item in a table is a ...
Record
Field
Table
Each item from this list is classified as...
Name, Birthdate, Street, County , PostCode
Table
Record
Field
Which of the following is an example of a record?
347
ChannelType
351, Nature, Documentary, Bling, False
Which of the following is an example of a field?
347
ChannelType
351, Nature, Documentary, Bling, False
Which of the following is an example of a field?
347
ChannelType
351, Nature, Documentary, Bling, False
The HD field is using the data type Boolean
True
False
Which of the following is an example of a record?
Artist
Game Over
002, Tail, Seeing You, 2.7, 0, True
Which data type would be most suitable for Length?
Integer
Float/Double
Boolean
String
An Index is used to
Duplicate data.
Quickly locate data without having to search every row.
Decrease the speed of data retrieval.
Create a list with a lot of information.
What is a relationship in database?
A system to encourage missing data.
A collection of irrelevant data merged together.
Rather than having data organised in a single table, the data will be organised in separate tables.
A system which is takes up a lot of useful space.
What is important when designing a database?
A table should contain data related to multiple subject types.
Always design the database in a colourful manner.
Make sure you include different font sizes and types.
A table should contain data related to a single subject type.
What is an important fact when creating fields in a database?
None of the following.
Each field in a table should contain several types of data.
Each field in a table should contain only one type of data.
Each cell is unique.
Name an appropriate data type for a field containing decimal values.
Text
Number
Calculated
Date/Time
What property is used to automatically enter a specific field value for new records?
Random Value.
Auto Value.
None of the following.
Default value.
What could happen if a data type is changed in an existing table?
Data will be duplicated.
Data will be saved.
Data could be lost.
Data will be stored in a different database.
Which one of the following is responsible for recovery of data after a database crash?
A database administrator.
A sales and marketing manager.
An ICT teacher.
A technician.
What is a query used for in a database?
Delete data.
Edit data.
Filter data.
Extract and analyse data.
What is the main use for reports?
To access data from a database to manipulate it or retrieve it.
To compile information for printing.
To enter, edit, or display data from a table.
To summarize data.
What is a database?
A systematic collection of data.
A random collection of data.
A spreadsheet workbook.
Information about clients and students.
A health club wants to find all the members who use the club 3 days or more a week. What will the search criteria for 'days' be?
>3
<3
<=3
>=3
