wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Year 11 Extra work

Total questions: 20

Worksheet time: 9mins

Name
Class
Date
1.

What is the primary organizational structure of a flat file database?

a)

Tables

b)

Columns

c)

Fields

d)

Rows

2.

What is the term for a single entry in a database representing information about a person or entity?

a)

Table

b)

Record

c)

Field

d)

Column

3.

What operation allows Bob to find a specific person in his address book?

a)

Sort

b)

Search

c)

Filter

d)

Group

4.

Which field type stores data like calendar dates in a database?

a)

Text

b)

Number

c)

Date

d)

Graphic

5.

Which of the following is NOT a type of field in a database?

a)

Text

b)

Numeric

c)

Sound

d)

Calculated

6.
Jennifer is creating a database for several customers. How will she list the Customer ID?  
a)
  Yes/No
b)
  Data 
c)
 Number
d)
 Currency
7.

When Using Computerized Databases

a)

You Can Easily Search For A Particular Record Quickly

b)

You Can't Easily Create more Backup Copies

c)

Its Hard To Update Or Make Changes

d)

It Can Take A While To Search For A Particular File

8.

A Primary Key Is

a)

A unique filed that identifies a particular record

b)

Table Unique Identifier

9.

A DBMS is responsible for

a)

creating tables and linking them together

b)

adding data inside the database

c)

Modify or delete existing data

d)

all of the listed answers

10.
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
11.
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
12.
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
13.
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
14.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
15.
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
16.

In a database about school form groups, you would need to create a different _____ for each year group

a)

Table

b)

Record

c)

Field

17.

Which of the following is an example of a record?

a)

347

b)

ChannelType

c)

351, Nature, Documentary, Bling, False

18.

Which of the following is an example of a field?

a)

347

b)

ChannelType

c)

351, Nature, Documentary, Bling, False

19.

The HD field is using the data type Boolean

a)

True

b)

False

20.
In which of the following must the data be unique?
a)
the foriegn key
b)
the primary key
c)
the junction table
d)
the common field