wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Unit 05 - Create and use databases

Total questions: 20

Worksheet time: 24mins

Name
Class
Date
1.

A database that understands how information is related is called __________.

a)

A connected database

b)

A linked database

c)

A relational database

d)

An Access database

2.

What type of work is included in a database administrator?

a)

Entering data and preparing reports

b)

Performing surveys

c)

Writing letters of request

d)

All of the above

3.
When is a database used?
a)
To perform searches for info on the internet
b)
To create and format text documents for sharing info
c)
To display information in a picture form instead of words
d)
To store and organize large amounts of information for quick searching
4.
Databases store information in __________, which are made up of columns and rows.
a)
tabs
b)
tables
c)
ribbons
d)
image files
5.
Relational databases consist of multiple tables of information that are related through:
a)
big data
b)
ID columns
c)
header rows
d)
common fields
6.
Which type of application should you use if you need to store a large quantity of data in an organized format that you can easily query?
a)
Database
b)
Presentation
c)
Spreadsheet
d)
Word Processor
7.
Which statement about databases is true?
a)
Database files are prone to inadvertent data corruption.
b)
Database files can contain only a limited number of records.
c)
Multiple people can use the same database data simultaneously.
d)
Database applications are used to "crunch" numbers for numeric analysis.
8.
Which Microsoft Office application should you use for database creation and manipulation?
a)
Bing
b)
Excel
c)
Access
d)
Googl
9.
The Title Bar in Access usually contains what information?
a)
The names of the application and the Database.
b)
The name of the application.
c)
The names of the application and user.
d)
The names of the file and user.
10.
The options on the Ribbon will _______________. 
a)
change depending on the tab
b)
change depending on the view
c)
stay the same depending on the tab
d)
stay the same depending on the view
11.
You will find these options on the backstage view of Access except __________________. 
a)
print
b)
save
c)
open
d)
create
12.
What options are available by default on the Quick Access Toolbar? 
a)
Save, Redo and Undo
b)
Print, Save and Redo
c)
Redo, Undo and Help
d)
Print, Save and Delete
13.
Which of the following is an advantage of using a database?
a)
More than one person can use it at a time.
b)
Easy to learn.
c)
Useful for storing and crunching small amounts of data.
d)
Can easily present information in a graphical form.
14.

Relational Databases save information as...

a)

text files

b)

Separate Documents

c)

Structured tables without relations

d)

Structured tables with relations

15.

Many to many relation means..

a)

One table record relates to another record in another table

b)

One table record relates to many records in another table.

c)

More than one table record relates to another table record

d)

More than one table record relates to more than one record in another table

16.

What best describes a data dictionary?

a)

A set of files that contains meta data for a database

b)

A definition of relationships used in a database

c)

A set of SQL statements to create a database

d)

A glossary of terms used in database structures

17.

Which one of the following best describes a relational database?

a)

Each entity in an entity-relationship (ER) diagram converts to a table

b)

Key values must be null before the entity relationship is defined

c)

Primary keys must be joined in a one to many entity relationship

d)

Entities are defined by a list of unique attributes

18.

A name of a database, table, or table column is known as...

a)

Identifier

b)

Data Definition

c)

Administration

d)

Security

19.

A query that removes structure and data of a table

a)

Truncate

b)

Drop

c)

Delete

d)

None of the above

20.

The steps to create a blank database are

a)

Open access 2016

b)

select the template Blank Desktop Database and give filename

c)

Change the default location by clicking on the folder icon

d)

Click on the "Create " button

e)

All of the above

Similar Resources on Wayground

Trivia CMAE2020

20 questions

Trivia CMAE2020

quiz

Worksheet

•

University

Distribucion hipergeometrica y Poisson

18 questions

Distribucion hipergeometrica y Poisson

quiz

Worksheet

•

University

KOMUNIKASI BISNIS 1

15 questions

KOMUNIKASI BISNIS 1

quiz

Worksheet

•

University

REVISION 4 : TOPIC 9 [ACCOUNTING FOR NON-CURRENT ASSETS]

20 questions

REVISION 4 : TOPIC 9 [ACCOUNTING FOR NON-CURRENT ASSETS]

quiz

Worksheet

•

1st Grade - University

Revisão - Empreendedorismo Criativo

20 questions

Revisão - Empreendedorismo Criativo

quiz

Worksheet

•

University

SM_1

18 questions

SM_1

quiz

Worksheet

•

University

Ch1: Measurement, Estimating

16 questions

Ch1: Measurement, Estimating

quiz

Worksheet

•

University