WorksheetsTopic 5 - Databases
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
What is a relational database?
a)
A database that is built from a set of unique tables containing data about one entity
b)
A database with one single large table
c)
A set of many databases about numerous, related topics
2.
What is normalisation?
a)
Making databases larger so that they are easier to use
b)
Analysing how to make databases more efficient by using separate tables to reduce redundant data
c)
Setting the correct data types to all of the data in a database
3.
Setting the correct data types to all of the data in a database
a)
Built from a set of unique tables, each with a primary key, linked together with relationships
b)
Built upon one large table containing all the attributes, used to record a limited amount of data
c)
A collection of separate tables in which all the data for the system is stored
4.
What is a foreign key?
a)
A foreign key is a primary key that appears in another table to create a relationship between the two tables
b)
A foreign key is a field that does not belong in that table
c)
A foreign key is a field that is a unique identifier in that entity
5.
What would you use a query for?
a)
To export and present information from a database
b)
To enter data into a database
c)
To search and filter a database
6.
What is an entity?
a)
A table in a database
b)
A field in a database
c)
A record in a database
7.
Why would you create a report?
a)
To store data in the database
b)
To present data in a user-friendly way
c)
To search the database
8.
What type of relationship exists between a person and national insurance number?
a)
One to One
b)
One to Many
c)
Many to Many
9.
What type of relationship exists between courses and students?
a)
What type of relationship exists between courses and students?
b)
One to Many
c)
Many to Many
10.
What type of relationship exists between a company and employees?
a)
What type of relationship exists between a company and employees?
b)
One to Many
c)
Many to Many
11.
A database is:
a)
An organised collection of data or information
b)
A collection of software
c)
A collection of drivers
12.
Which of the following is a tool to store, edit and organise a database?
a)
A database management system (DBMS)
b)
A database
c)
SQL
13.
What is SQL?
a)
A programming language used to search and query databases
b)
A programming language used to build databases
c)
A programming language used to debug databases
14.
Converting data into a secret code so that it cannot be read by an unauthorised person is called what?
a)
Encryption
b)
Inscription
c)
De-encryption
15.
Which of these is NOT an advantage of relational databases?
a)
Data is stored in one table
b)
Details need to be entered once
c)
Duplication is avoided
16.
What is a foreign key?
a)
A foreign key is a primary key that appears in another table to create a relationship between the two tables
b)
A foreign key is a field that is a unique identifier in that entity
c)
A foreign key is a field that does not belong in that table
17.
Reports, queries and input forms
a)
What is a database?
b)
What are features of a DBMS?
c)
What can't you do in a database?
d)
Flat file databases allow you to create?
18.
Select * from students where student_name = 'David'
a)
Will only show me first name and surname for people called David
b)
Will only show me first name for people called David
c)
Will show me all fields in the students table for people called David
19.
Select fname and sname from students
a)
Will show me all fields in the students table and all records
b)
Will only show me fname and sname fields from the students table for all records
c)
Will show me one records from students table
20.
I cannot have duplicate data in my records...
a)
I am a flat file database
b)
I am a relational database
c)
I am a table in a database
100 %
