wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

6.7 Databases Quiz

Total questions: 35

Worksheet time: 17mins

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 records

d)

A calculator

2.

A sports club needs to store information about each member. The all the information about each member is called a:

a)

Field

b)

File

c)

Table

d)

Record

3.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
4.

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' query criteria?

a)

>3

b)

<3

c)

<=3

d)

>=3

5.

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)

Report

b)

Form

c)

Query

d)

Sort

6.

What data type would be used to store the following item code: 0024

a)

Text

b)

Numeric

c)

Calculated

d)

Boolean

7.

The school wants to sort the data in alphabetical order by staff Surname. How will they sort it?

a)

Ascending order

b)

Descending order

8.

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

a)

Data Types

b)

Filters

c)

Sorts

d)

Validations

9.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
10.

The four main objects of a database consist of:

a)

form, table, query, report

b)

filter, table, database, query

c)

form, data type, record, query

d)

form, record, field, report

11.
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
12.
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
13.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
14.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
15.
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
16.
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
17.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
18.
A group of related records.
a)
Entity
b)
Validation
c)
Field
d)
Filter
19.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
20.
A method of only displaying records in a table that match specific criteria...
a)
Filter
b)
Validation
c)
Sort
d)
Verification
21.
A method for checking data entered e.g. Proof Reading or Double Entry.
a)
Verification
b)
Filter
c)
Data Types
d)
Query
22.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
23.
Which of these could be a primary key?
a)
Centre number
b)
Surname
c)
Teacher name
d)
Students addresses
24.
How many records are in this database?
a)
8
b)
5
c)
10
d)
12
25.
What is the primary key in this database?
a)
Emp_Id
b)
Last Name
c)
Gender
d)
Title
26.
Which of the following is a common database program?
a)
Access
b)
Excel
c)
InDesign
d)
Badata
27.
What causes most errors in a database?
a)
SQL
b)
humans
c)
servers
d)
Internet access
28.
Which is the best example of a primary key?
a)
Driver's License Number
b)
Home Runs Hit
c)
Price
d)
First and Last Name
29.
The front-end of a database is known as a _____.
a)
form
b)
report
c)
query
d)
website
30.

The best data type to choose for date of birth would be

a)

Number

b)

Date/Time

c)

Text

d)

Currency

31.

In a database, data is stored in

a)

Queries

b)

Forms

c)

Reports

d)

Tables

32.
8. Which ribbon tab do you use to make a new table?
a)
File
b)
Home
c)
Create
d)
External Data 
33.
A database application can perform which of the following activities?
a)
Add records
b)
Display / read records
c)
Update records
d)
All of the above
34.
Which one of the following should be taken as a primary key?
a)
Name
b)
DepartmentID
c)
Department
d)
Street
35.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street

Similar Resources on Wayground

Introduction to Computers

30 questions

Introduction to Computers

quiz

Worksheet

•

10th Grade

Páginas web

30 questions

Páginas web

quiz

Worksheet

•

6th Grade - University

Security and Ethics

34 questions

Security and Ethics

quiz

Worksheet

•

7th - 10th Grade

Copyright or Copywrong 4A

40 questions

Copyright or Copywrong 4A

quiz

Worksheet

•

10th - 12th Grade

Networks & Connections Revision

32 questions

Networks & Connections Revision

quiz

Worksheet

•

9th - 12th Grade

Q4 PRE-FINALS

40 questions

Q4 PRE-FINALS

quiz

Worksheet

•

10th Grade

Python Quiz II

30 questions

Python Quiz II

quiz

Worksheet

•

9th Grade - University

Linguagem C - Loops e Array

30 questions

Linguagem C - Loops e Array

quiz

Worksheet

•

10th Grade