Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

database

Total questions: 40

Worksheet time: 22mins

Name
Class
Date
1.
A tool used to organize, store, retrieve and communicate (report on) groups of related information.
a)
Spreadsheet
b)
Database
c)
Word Processing
d)
Desktop Publishing
2.
A telephone book is a good example of a database.
a)
True
b)
False
3.
What are the Four main objects in a database?
a)
Balance, Proximity, Unity, Consistency
b)
Spell Check, Grammar, Ruler, Tools
c)
Tables, Queriers, Forms, Reports
d)
Cells, Columns, Rows, Entry
4.
What is used to store data and are the essential building blocks of databases?
a)
File
b)
Record
c)
Forms
d)
Tables
5.
Tables organize data.
a)
True
b)
False
6.
What is a group of related fields in a database?
a)
Data
b)
Item
c)
Record
d)
Entry
7.
What data type allows you to enter lengthy amounts of text?
a)
Memo
b)
Currency
c)
Date/Time
d)
Number
8.
The maximum size for data stored in a field.
a)
Catption
b)
Input Mask
c)
Field Size
d)
Entry
9.
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
a)
Query
b)
Report
c)
Database 
d)
Spreadsheet
10.
A Primary Key is a code that uniquely identifies a _____________ in a Database.
a)
Record 
b)
Field 
c)
Text 
d)
Number
11.
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
a)
Cell
b)
Field
c)
Column
d)
Record
12.

In a database table, rows are called __________

a)

Fields

b)

Records

c)

Primary Keys

d)

Foreign Keys

13.

Forms, queries, and reports are created based on the data in the _________

a)

Forms

b)

Tables

c)

Reports

d)

Spreadsheets

14.
To sort from the smallest to the largest (from A to Z and 0 to 9)
a)
Ascending
b)
Descending
c)
Auto Sort
d)
Advanced Sort/Filter
15.

Each item of information within a record.

a)

form

b)

field

c)

record

d)

report

16.

All data for a particular entry, such as a client in your client card file

a)

report

b)

form

c)

field

d)

record

17.

View that shows the “background” or working of a table

a)

design view

b)

datasheet view

c)

form view

d)

layout view

18.

View that is similar to a spreadsheet, place to enter data

a)

form

b)

datasheet

c)

design

d)

detail

19.

What is a suitable data type for usage?

a)

Text

b)

Number

c)

Currency

d)

Yes/No

20.

Which data type would be most suitable for the 'Age' field?

a)

Currency

b)

Date & Time

c)

Number

d)

Memo

21.

Data organized and formatted for printing.

a)

form

b)

table

c)

report

d)

query

22.
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
23.
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
24.
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
25.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
26.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
27.
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
28.
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
29.
The school wants to sort the data by staff Surname.  How will they sort it?
a)
Ascending order
b)
Descending order
30.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
31.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
32.

Which of the following is an example of a record?

a)

347

b)

ChannelType

c)

351, Nature, Documentary, Bling, False

33.

Which of the following is an example of a field?

a)

347

b)

ChannelType

c)

351, Nature, Documentary, Bling, False

34.

The HD field is using the data type Boolean

a)

True

b)

False

35.

Which of the following is an example of a record?

a)

Artist

b)

Game Over

c)

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

36.

Which data type would be most suitable for Length?

a)

Integer

b)

Float/Double

c)

Boolean

d)

String

37.

Which of the following is an example of a field?

a)

TimesPlayed

b)

004

c)

Holidays

38.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
39.
I give one the ability to present information in an easy-to-read format. I summarize and print information from the  query search.
a)
form
b)
table
c)
query
d)
report
40.
A unique identifier for a category is known as what?
a)
entry
b)
field
c)
record
d)
table

Similar Resources on Wayground

Topic 1 Introduction to Computer System

40 questions

Topic 1 Introduction to Computer System

quiz

Worksheet

•

University

Bilgisayar ile İlgili Temel Kavramlar

40 questions

Bilgisayar ile İlgili Temel Kavramlar

quiz

Worksheet

•

University

Arsitektur Komputer

40 questions

Arsitektur Komputer

quiz

Worksheet

•

University

ข้อสอบปลายภาควิชาพื้นฐานธุรกิจดิจิทัล 1/2564

40 questions

ข้อสอบปลายภาควิชาพื้นฐานธุรกิจดิจิทัล 1/2564

quiz

Worksheet

•

University

CSCI0823 UnitTest_Finals

35 questions

CSCI0823 UnitTest_Finals

quiz

Worksheet

•

University

I/O devices

44 questions

I/O devices

quiz

Worksheet

•

University

COMP_FUND_PROG-QUIZ #1

35 questions

COMP_FUND_PROG-QUIZ #1

quiz

Worksheet

•

University

Kuis Sistem Komputer

45 questions

Kuis Sistem Komputer

quiz

Worksheet

•

10th Grade - University