NEW
Font size
S
M
L
XL
WorksheetsGCSE Database Theory
Total questions: 19
Worksheet time: 10mins
Name
Class
Date
1.
What does “SQL” stand for?
a)
Standard Query Language.
b)
Structured Query Language.
c)
Structured Quick-access Language.
d)
Standard Questioning Language.
2.
What is a DBMS?
a)
It runs a database, and can provide control over user permission levels, provides both a visual and SQL interface and can allow a database to work across multiple devices.
b)
It is a technology which reduces lag time when running a query.
c)
It is the organisation that set up and maintains SQL.
d)
It is a Database Backup Management system that can be switched to if an active database fails.
3.
What does a Relationship do within a database?
a)
It reduces data redundancy by linking fields in different tables.
b)
It shows which users in a database are related.
c)
It increases data redundancy by linking fields in different tables.
d)
The fields are the vertical columns in a table.
4.
What is data redundancy?
a)
Data that is repeated multiple times.
b)
Data that is safe from SQL attacks.
c)
Data that is weak to SQL attacks.
d)
Data that has no use anymore.
5.
What does data validation do?
a)
Checks that an input fits certain parameters such as length.
b)
Checks that inputted data is completely correct.
c)
Checks that there is no redundant data in a field.
d)
Checks that the correct SQL Query has been used.
6.
What is QBE?
a)
A graphical, form based method of running a query on a database.
b)
A way of achieving data validation.
c)
An alternative to a DBMS.
d)
Another name for an SQL query.
7.
A database is separated from the applications that use it so that…
a)
Different groups of users can have custom interfaces
b)
The tables don’t get mixed up
c)
Things are kept simple using “divide and conquer”
d)
It takes up less disk space
8.
An advantage of using SQL instead of QBE is:
a)
It is a standardised system and therefore can easily communicate with other programs that use SQL.
b)
It is more intuitive to use than the QBE
c)
It prevents data redundancy due to not using an overly-complicated DBMS
d)
It increases the chance of a failover system being activated, protecting data in the event of a malicious attack.
9.
A database is a store of data that is...
a)
persistent and organised
b)
persistent and disorganised
c)
temporary and organised
d)
temporary and disorganised
10.
A database form is useful for...
a)
viewing and entering data
b)
only viewing data
c)
only entering data
d)
storing data
11.
A database table is used to...
a)
store data
b)
encrypt data
c)
retrieve data
d)
present data neatly
12.
A database query is used to...
a)
find data based on certain criteria
b)
add new data
c)
store data
d)
present data neatly
13.
A database report is used to...
a)
add or edit data
b)
store data
c)
find data using a search
d)
present data in a neat format
14.
A module in a database...
a)
is some code that automates a useful function
b)
is a collection of tables
c)
is a 'cluster' of databases joined together
d)
forms a link between ables
15.
Which answer shows a pair of entities?
a)
Student and teacher
b)
UserID and DOB
c)
TeacherName and Subject
d)
ClassID and Teacher
16.
What would be a good query expression to find the students in a year group?
a)
DOB>31/9/2000 AND DOB<1/9/2001
b)
Age = 15 OR Age = 16
c)
DOB>31/9/2000 OR DOB<1/9/2001
d)
DOB>31/9/2000 AND Age = 16
17.
Which query expression would be best to find students who are in form B4 and are male?
a)
Gender = "M" AND form = "B4"
b)
Gender = M AND form = "B4"
c)
Gender = "M" AND form = B4
d)
Gender = M AND form = B4
18.
Which of these is NOT a proper method of validation?
a)
spell check
b)
data type check
c)
range check
d)
presence check
19.
What is an ox-bow lake?
a)
A remnant meander, left after a river has straightened its course.
b)
A post-glacial lake caused by a moraine dam
c)
A small lake normally found in a 'birds-foot' delta
d)
A lake on a flood plain formed by man made levees.
Reset
