NEW
Font size
S
M
L
XL
WorksheetsOCR J275 Databases
Total questions: 32
Worksheet time: 16mins
Name
Class
Date
1.
What is meant by a database?
a)
A persistent store of organised data.
b)
Used to calculate financial data and for modelling.
2.
What is meant by the phrase persistent storage?
a)
Volatile storage of data on a secondary storage device like a hard disk.
b)
Non-volatile storage of data on a secondary storage device like a hard disk.
3.
Give two examples of a paper-based database.
a)
Address Book
b)
Diary
c)
Calendar
d)
Mobile Phone Contacts
4.
Which of the following is NOT an advantage of computer based databases over paper based databases.
a)
Easily organise the data using sort (ascending/descending) or filters.
b)
Can be backed up to avoid loss.
c)
Can be shared with colleagues by attaching to emails.
d)
They have to be locked in filing cabinets.
5.
Why might a database stored on a computer be less secure than a paper based database?
a)
Easier to access as you don't need to enter a building or filing cabinet. They can be hacked from anywhere in the world.
b)
Smaller physical size and easier to steal
c)
Both answers are correct
6.
What is a Database Management System (DBMS)?
a)
System that has applications/features to allow databases to be created, interrogated and maintained.
b)
System that enables you to carry out financial calculations.
7.
Name a data handling software available as an 'off-the-shelf' product that you could use to create a database.
a)
Microsoft Word or Open Writer
b)
Microsoft PowerPoint or Open Impress
c)
Microsoft Access or My SQL
d)
Microsoft Excel or Open Calc
8.
Define the term 'field'.
a)
A field in a table that uniquely identifies a record.
b)
A collection of data organised into records and fields.
c)
Data stored about one instance of an entity e.g. one person or one object.
d)
One specific data item being stored such as surname or date.
9.
How many fields are in this table?
a)
6
b)
10
10.
Define the term 'record'.
a)
Data stored about one instance of an entity e.g. one person or one object.
b)
A collection of data organised into records and fields.
c)
One specific data item being stored such as surname or date.
d)
A field in a table that uniquely identifies a record.
11.
What is meant by an 'entity'?
a)
A collection of data organised into records and fields.
b)
A category of, for example a person, object or event about which data is stored in a table.
c)
A field in a table that uniquely identifies a record.
d)
One specific data item being stored such as surname or date.
12.
How many records are in this table?
a)
6
b)
10
13.
What is meant by a primary key?
a)
A field in a table that uniquely identifies a record.
b)
A field in one table that is the primary key in another table, used to create a relationship between two tables.
14.
What is meant by a foreign key?
a)
A field in a table that uniquely identifies a record.
b)
A field in one table that is the primary key in another table, used to create a relationship between two tables.
15.
What is meant by a 'table'?
a)
A category of, for example a person, object or event about which data is stored in a table.
b)
A field in a table that uniquely identifies a record.
c)
Represents a real world entity. Organised into records and rows.
d)
Data stored about one instance of an entity e.g. one person or one object.
16.
A flat file database is a persistent organised store of data where data is stored as a collection of related tables to minimise data redundancy - True or False?
a)
True
b)
False
17.
A relational database is a persistent organised store of data where data is stored as a collection of related tables to minimise data redundancy - True or False?
a)
True
b)
False
18.
What is meant by data redundancy/duplication?
a)
Where the same data is stored more than once unnecessarily.
b)
Where different versions of the same data have different values because duplicate versions have been stored and updated differently.
19.
What type of validation would you use for a postcode?
a)
Length Check.
b)
Format Check
c)
Range Check.
d)
Check Digit.
20.
What is the purpose of validation checks?
a)
A human check to verify that data entered has been typed in correctly. Data is entered twice and both versions are compared.
b)
A computer check to ensure data entered is sensible and reasonable, they do not check the accuracy.
21.
What validation is used to check the data is in the right format e.g. text or number?
a)
Format Check.
b)
Length Check.
c)
Range Check.
d)
Presence Check.
22.
For a school database what type of validation could be set for the year group field with the following criteria >=11 and <=16?
a)
Length Check.
b)
A Range Check.
c)
A Spell Check.
d)
A Check Digit.
23.
What type of validation would use to ensure a key field in a database cannot be left blank?
a)
Presence Check.
b)
Range Check.
c)
Length Check.
d)
Spell Check.
24.
I am a snapshot in time of the database that can be printed, sorted and grouped. I may be printed to look at monthly sales
a)
Form
b)
Report
c)
Query
d)
Filter
25.
What is the purpose of verification?
a)
It double checks that data entered has been typed in correctly. Data is entered twice and both versions are compared.
b)
They are carried out to ensure data entered is sensible and reasonable, they do not check the accuracy.
26.
This is used to input data, one record at a time - what is it?
a)
A report.
b)
A query.
c)
A form.
d)
A table.
27.
Which feature of a DBMS enables a database to be interrogated based on specific criteria?
a)
Query.
b)
Report
c)
Form
d)
Relationship
28.
What type of relationship would you setup for a shop that hired out films to customers?
a)
One-to-many
b)
One-to-one.
29.
Which of the following are logical operators that can be used in database queries?
a)
AND
b)
OR
c)
NOT
d)
All 3 are logical operators.
30.
You want to create a query to find all the people who live in London. What criteria would you enter in the field city?
a)
London
b)
=LONDON
c)
=london
d)
=London
31.
What criteria would you use in the field City to find people who lived in Manchester and London
a)
=london OR manchester
b)
=London AND Manchester
32.
What criteria would you use in the field Age to find all the people aged 18 or below?
a)
>=18
b)
<=18
c)
=18
d)
Greater or equal to 18
Reset
