wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Databases

Total questions: 24

Worksheet time: 12mins

Name
Class
Date
1.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
2.
Which of the following describes a relational database?
a)
Access
b)
A database that has a table
c)
There are two or more tables that are linked using the primary keys
d)
There are more than one table that have duplicate data
3.
A sports club needs to store information about each member.  The individual information about each member is called a:
a)
Field
b)
File
c)
Table
d)
Record
4.
One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?
a)
Amend the record
b)
Delete the field
c)
Delete the record
d)
Delete the file
5.
The Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?
a)
Add another field
b)
Amend a record
c)
Add a new record
d)
Delete a record
6.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
7.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
8.
A scout company have a database with records of all the scouts.  They want to create a list of all scouts who are under 15 and their achievements. What would they use? 
a)
SQL UPDATE command
b)
Form 
c)
SQL SELECT Query
d)
Sort
9.
A gym has a database with all their members they want to include email addresses in the database, what will they do?
a)
Add a record
b)
Add a field
c)
Edit a record
d)
Delete a field
10.
A health club wants to find all the members who use the club 3 days or more a week.  What will they put in the query in the 'days' SQL query criteria?
a)
>3
b)
<3
c)
<=3
d)
>=3
11.
The health club stores the ages of its members.  What validation check would be used on the age field?
a)
Restricted choice
b)
Length
c)
Presence
d)
Range
12.
What data type would be used to store the following item code:   0024
a)
Text
b)
Integer
c)
Real
d)
Boolean
13.
The school wants to sort the data by staff Surname.  How will they sort it?
a)
Ascending order
b)
Descending order
14.
A film club stores details of all the films it shows.  One of the fields is Genre (sample data: Action, Horror, Family, Romance etc).  What validation would be most suitable for this field?
a)
Length
b)
Presence
c)
Range
d)
Restricted Choice
15.
IKEA stores details of it's stock on a relational database.  Along with a unique stock code, all items are stored in coded aisles eg. BLU24, ORA23, YEL49 etc.  What type of validation would be used on this aisle code?
a)
Presence
b)
Length
c)
Range
d)
Field
16.

Which of the following is an example of a record?

a)

Artist

b)

Game Over

c)

002, Tail, Seeing You, 2.7, 0, True

17.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
18.

Text, Integer, Currency, Boolean and Date/Time are all examples of...

a)

Data Types

b)

Filters

c)

Sorts

d)

Validations

19.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
20.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
21.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
22.

What is the definition of a Foreign Key?

a)

A field in a table that is written in another language

b)

A field in a table that links to the World Wide Web

c)

A field in a table that cannot be edited or accessed by users

d)

A field in a table that is used as a link to a field in another table

23.

How would you define a relational database?

a)

A database consisting of data relating to families

b)

An online database

c)

A database linked to another database

d)

A database consisting of multiple tables, that are linked using keys

24.

What is the definition of a database entity?

a)

Another name for a table

b)

A way of performing searches and sorts in a database

c)

It represents people, places, objects or things stored in tables in a database

d)

A way of linking tables in a database

Similar Resources on Wayground

Revisão - Administração de Redes

20 questions

Revisão - Administração de Redes

quiz

Worksheet

•

1st - 12th Grade

Pointers

20 questions

Pointers

quiz

Worksheet

•

12th Grade

Google Sheets

21 questions

Google Sheets

quiz

Worksheet

•

12th Grade

Java - 11TPI

20 questions

Java - 11TPI

quiz

Worksheet

•

9th - 12th Grade

Summative Test in EMPTECH 3rd

20 questions

Summative Test in EMPTECH 3rd

quiz

Worksheet

•

12th Grade

History of Package Design

20 questions

History of Package Design

quiz

Worksheet

•

9th - 12th Grade

TIK

20 questions

TIK

quiz

Worksheet

•

12th Grade

NP IT Quiz ปริศนาไอที #4

20 questions

NP IT Quiz ปริศนาไอที #4

quiz

Worksheet

•

9th - 12th Grade