Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Concepts Quiz

Total questions: 81

Worksheet time: 43mins

Name
Class
Date
1.

In terms of how it stores and displays data, which Office product is Access most similar to?

a)

Word

b)

Excel

c)

Outlook

d)

PowerPoint

2.

What is the specific term for data entered into a database?

a)

record

b)

file

c)

information

d)

input

3.

What advantage does a database have over a spreadsheet?

a)

easier to perform calculations

b)

better for presentations

c)

better visuals/illustrations, like graphs and charts

d)

better tracking of inter-related information

4.

What database-focused software is used to build websites and blogs?

a)

customer management software

b)

content management systems

c)

data design tools

d)

internet service providers

5.

What is the first step when designing a new database?

a)

asking what it will be used for

b)

deciding who the customer will be

6.

Microsoft Access is best described as what type of software?

a)

content management system

b)

data storage system

c)

database management system

d)

spreadsheet populator system

7.

What is the name of LibreOffice's counterpoint to Microsoft Access?

a)

Cabinet

b)

Base

c)

Data

d)

Balance

8.

The most common database language is:

a)

SQL

b)

Python

c)

Ruby

d)

C++

9.

What is SQL primarily used for?

a)

converting spreadsheets to database files

b)

creating charts from data

c)

making database queries

d)

creating an index of data

10.

What is an example of numeric data?

a)

float

b)

date

c)

character

d)

time

11.

What is an example of an integer?

a)

3-30

b)

5-22

c)

3-10

d)

5

12.

What is an example of a float?

a)

5-22

b)

3-30

c)

N-5

d)

May 3- May 5

13.

What is an example of data that would generally be stored as a float?

a)

payments

b)

dates

c)

times

d)

social security numbers

14.

What is an example of data that would generally be stored in character format?

a)

birth date

b)

product name

c)

income

d)

age

15.

Imagine a database keeping track of participants in a study about how well a new treatment lengthens lifespan for otherwise terminally ill patients. What is an example of a record that would make sense to store in binary format?

a)

whether the patient is still alive

b)

what stage in the treatment cycle the patient is on

c)

what name the patient prefers to be called

d)

when the patient started the new treatment

16.

In response to a survey about college preferences, what is an example of data that could be stored in either character or binary format?

a)

What race do they identify as?

b)

How old is the respondent

c)

Which school are they most interested in?

d)

Did they graduate from high school?

17.

Ceres is the architect of a database that will store a single record for each painting in a gallery, including the painting's name, the artist's name, and an image of the painting itself. What format makes sense for this record?

a)

character

b)

float

c)

integer

d)

BLOB

18.

What is one of the most common records stored as short text in databases?

a)

date of birth

b)

age

c)

name

d)

cost of an item

19.

What is an example of a record that would be stored as a hyperlink in a database?

a)

home page

b)

phone number

c)

first and last name

d)

Social Security number

20.

Why should users avoid including empty fields in a database?

a)

They can cause errors

b)

They make it easy to make mistakes in data entry

c)

They distract the reader

d)

They can slow down queries

21.

Addresses and phone numbers stored for a particular contact in a database are said to share what?

a)

tether

b)

relationship

c)

table value

d)

intersection

22.

The most common way to retrieve information from a large database using SQL is to:

a)

look directly at the database

b)

activate a filter

c)

perform a query

d)

use an online search tool

23.

What query command can change the values in an existing table?

a)

INSERT

b)

REPLACE

c)

OVERWRITE

d)

NEW

24.

What term refers to adding new records to a database?

a)

insert

b)

overwrite

c)

append

d)

drop

25.

What is the last step required before a query takes effect?

a)

command

b)

run

c)

return

d)

overwrite

26.

What risk is being taken when a user cuts and pastes data from one database to another?

a)

If the fields aren’t an exact match, it can damage the data.

b)

If the data being cut is too large, it won’t fit in the database.

c)

The paste command won’t work at all in Access.

27.

What is used to automatically amend an existing database with new or updated information?

a)

cut and pasting

b)

a database form

c)

a data import

d)

a relationship editor

28.

To make a new query or database form in Access, what tab should a user select?

a)

Create

b)

File

c)

Insert

d)

Format

29.

What Print option allows a user to print the results of a query rather than a whole database?

a)

Print Table

b)

Print Filter

c)

Print Selection

d)

Print Return

30.

When should a data warehouse be used instead of a transactional database?

a)

when storing sensitive customer information

b)

when storing information pulled from an online form

c)

when the data needs to be accessed in a flexible way

d)

when huge volumes of data will be stored

31.

What is an example of an institution very likely to use a data warehouse?

a)

small, local nonprofit

b)

large university

c)

residential pre-school

d)

national sports team

32.

What is an advantage of a data warehouse over a transactional database?

a)

It can pull information in from data forms.

b)

It provides a higher level of security.

c)

It can be fed data from multiple, different sources.

d)

It's cheaper to establish and maintain.

33.

Fabio is using data mining to predict which of his customers will probably buy a car in the next six months. Which data mining technique should he use?

a)

regression

b)

association rule discovery

c)

classification

d)

clustering

34.

David is using data mining to find out what side dishes are most popular with each of his meals. What technique is best for this analysis?

a)

regression

b)

association rule discovery

c)

classification

d)

clustering

35.

Maria is trying to determine which customer base would be most interested in her latest invention: a self-cleaning baby crib. What data mining technique might she use to narrow down potential customers to a targetable marketing campaign?

a)

regression

b)

association rule discovery

c)

classification

d)

clustering

36.

Filip performed a data mining technique and found that his customers who bought three or more board games in a year shared a lot in common with customers who bought three or more video games a month. He believes he should try cross marketing, since the groups may be similar. What data mining technique does this scenario most illustrate?

a)

regression

b)

association rule discovery

c)

classification

d)

clustering

37.

At its root, data mining is about finding:

a)

visual illustrations of existing data.

b)

what motivated human behavior.

c)

ways to make more money.

d)

patterns in data.

38.

The database query to return all tables that are part of a database is:

a)

OPEN

b)

PRINT

c)

SHOW

d)

SELECT

39.

What database query is used to bring up particular records?

a)

OPEN

b)

PRINT

c)

SHOW

d)

SELECT

40.

What symbol is used to define the content that is being searched for in a database query?

a)

single quotes '

b)

parentheses ( )

c)

brackets [ ]

d)

double quotes "

41.

What refers to connecting database query commands to each other so they are performed at the same time to produce a more specific result?

a)

link

b)

relational

c)

chain

d)

sequence

42.

What commands bring a user to a screen in the Access Query Wizard that will allow them to add criteria for a query?

a)

Detail > Modify

b)

Design > New

c)

Query > Custom

d)

Define > Options

43.

What is the name of Microsoft’s database program alluding to?

4 lines
44.

What is the default order of an Access database query in the Query Wizard?

a)

Numerical order

b)

Alphabetical order

c)

Random order

d)

The order of the records in the database

45.

Unlike the desktop version, Access Online is automatically connected to:

a)

OneCloud

b)

OneDrive

c)

Microsoft Cloud

d)

There is no such thing as Access Online.

46.

Which Access command will change an existing record?

a)

Append

b)

Update

c)

Overwrite

d)

Amend

47.

Databases are generally the best tool for building a data-intensive website.

a)

True

b)

False

48.

Even small businesses need database management software, if only to open common database file types like .DB or .ACCDB.

a)

True

b)

False

49.

Generally speaking, if someone isn’t familiar with a database language, they should stick to spreadsheet software.

a)

True

b)

False

50.

Access is only available to Windows users.

a)

True

b)

False

51.

SQL is an acronym for Search Query Log.

a)

True

b)

False

52.

Formatting in a database file can determine what sort of data should be in a cell.

a)

True

b)

False

53.

A float is a range of numbers; an integer is a single number.

a)

True

b)

False

54.

An integer is a more secure type of data than a character.

a)

True

b)

False

55.

It's relatively easy to change the format of a particular field in a database after the field has been created.

a)

True

b)

False

56.

Relationships are transitional; if one database is connected with five others, those five are also linked to each other at the same time.

a)

True

b)

False

57.

Queries are not only used to search and retrieve data; they also can be used to manipulate data.

a)

True

b)

False

58.

Importing or exporting a database file is as simple as using the "Open" and "Save As" commands under the File menu.

a)

True

b)

False

59.

When someone signs up for a new website or subscribes to a mailing list online, they are filling out a database form.

a)

True

b)

False

60.

Content management services like WordPress allow users to create database forms via drag-and-drop functionality.

a)

True

b)

False

61.

In Access, reports are created via the "Create Reports" tool.

a)

True

b)

False

62.

Because they are smaller, transactional databases are better for very complex queries and can handle them faster and more efficiently than data warehouses.

a)

True

b)

False

63.

Data mining is generally done manually by a person.

a)

True

b)

False

64.

In business marketing analysis, before raw data collected through data mining is analyzed, outliers and incomplete data should be removed.

a)

True

b)

False

65.

Since they are backed by hard data, interpretations of mined data are entirely objective and absolute.

a)

True

b)

False

66.

All databases are spreadsheets, but not all spreadsheets are databases.

a)

True

b)

False

67.

Which physical object most resembles how a slide presentation works?

a)

a large chalkboard being written on

b)

a series of cue cards being cycled through

c)

a mixtape of someone’s favorite music

d)

a laser pointer used to highlight parts of a large poster

68.

What would make sense to include as a final slide in a slideshow?

a)

Contact the speaker at (email address) with further questions

b)

the title of the presentation

c)

a photo collage of all illustrations from the slideshow

d)

a textless slide with a solid red, blue, or green background

69.

What is the primary purpose of including visual slideshows with an oral presentation?

a)

It makes a presentation feel more professional

b)

It makes a presentation more interesting for the audience.

70.

What is the primary benefit of online presentation tools over offline tools?

a)

Online tools have expanded functionality and overall options.

b)

Online tools make collaboration easier.

c)

Online tools are, by nature, always free.

d)

Online tools can link to other files in a way offline tools can't.

71.

What is an example of a free online presentation tool?

a)

LibreOffice Show

b)

Apple Pages

c)

Google Slides

d)

Adobe Illustrator

72.

What’s an example of a paid offline presentation tool?

a)

LibreOffice Impress

b)

Adobe Flash

c)

Apple Pages

d)

Keynotes for Mac

73.

Charts can easily be imported into PowerPoint through which program?

a)

Excel

b)

Access

c)

Publisher

d)

Outlook

74.

Seraphina is trying to explain that over the last 12 months her business has experienced steady, reliable growth. Which element could she add to her slideshow to most effectively display this?

a)

table

b)

graph

75.

Kyle is creating a training slideshow for new hires and wants to explain the corporate structure—the organization of employees from CEOs and managers down to the new hires’ roles. What illustration would most effectively display this?

a)

table

b)

flowchart

76.

Candice is creating a presentation showing how the different experiments she ran had different effects on her subjects. What’s the best illustration for showing these results, which cover many different data points?

a)

table

b)

chart

77.

Katya is creating a presentation where she wants to show several short, common Japanese phrases and their equivalent version in other languages. What format is best for this purpose?

a)

table

b)

spreadsheet

78.

Almost all illustrations can be added to PowerPoint through which ribbon tab?

a)

Design

b)

Data

c)

Insert

d)

Home

79.

Which tab allows a user to edit an existing chart or graph in PowerPoint?

a)

Design

b)

Data

c)

Insert

d)

Home

80.

What is one of the easiest commands for creating a new organizational chart in PowerPoint?

a)

Design

b)

SmartArt

c)

Add-ins

d)

Header & Footer

81.

Which option would be most sensible to choose when creating a standard organizational chart for the chain of command in a military unit?

a)

Hierarchy

b)

Cycle

c)

Matrix

d)

List

Similar Resources on Wayground

EMPATIZAR

83 questions

EMPATIZAR

quiz

Worksheet

•

1st - 12th Grade