Computers: Understanding Technology Chapters 9-11

Front 1

In general, the broader the filtering criteria the more likely the database report will offer the desired content.

True
False

Back 1

False

Front 2

Which information system might a company use to plan future growth?

decision support system
factory automation system
management information system
office information system

Back 2

decision support system

Front 3

What is the spread of incorrect information in a database called?

data concealment
data corruption
data contamination
data confusion

Back 3

data contamination

Front 4

Microsoft Access is a widely used database management system for personal computers.

True
False

Back 4

True

Front 5

In contrast to a flat file model, relational database models

are slower to respond because the records must be searched sequentially.
consume more disk space.
allow fields to be shared among all the files in the database.
are simple and easy to use.

Back 5

allow fields to be shared among all the files in the database.

Front 6

Requesting information from a database involves the use of a

query language.
programming language.
natural programming language.
database language.

Back 6

query language.

Front 7

The purpose of record locking is to ensure that

data is not stolen by unauthorized users.
data is not lost in the event of a power failure.
only one user at a time edits or deletes a record.
there is no lag time between user request and system response.

Back 7

only one user at a time edits or deletes a record.

Front 8

In contrast to batch processing, transactional processing

occurs at a scheduled time.
rearranges data all at once.
takes place when a critical point has been reached.
tends to be done with smaller databases.

Back 8

tends to be done with smaller databases.

Front 9

When you receive duplicate mailings from a company, the company’s database has a problem with

contamination.
response time.
redundancy.
record locking.

Back 9

redundancy.

Front 10

A sign at the bank says that your deposit will not be posted to your account until the next business day. This delay is most likely due to

mixed batch/transactional processing.
online transactional processing.
batch processing.
transactional processing.

Back 10

batch processing.

Front 11

What is one of the most common data types?

numeric
autonumber
currency
date/time

Back 11

numeric

Front 12

An example of a database report generated by request is a

statement of taxes withheld from earnings.
monthly checking account statement from a bank.
transcript of college grades to send to a prospective employer.
paycheck.

Back 12

transcript of college grades to send to a prospective employer.

Front 13

Data types must be set for

records.
entities.
fields.
files.

Back 13

fields.

Front 14

In factory automation, CAM systems form a portion of a complete CIM system.

True
False

Back 14

True

Front 15

Which company is the world’s leading supplier of information management software?

Microsoft
Intel
IBM
Oracle

Back 15

Oracle

Front 16

Which data type allows unlimited character input?

number
hyperlink
text
memo

Back 16

memo

Front 17

Which one of the following refers to matching data from fields in various record files?

querying
data browsing
file processing
joining

Back 17

joining

Front 18

What is the purpose of database keys?

to back up and restore lost data
to protect and safeguard the database
to provide a means to search the database
to unlock the database management system software

Back 18

to provide a means to search the database

Front 19

In order to be accurate, a database must be continually validated.

True
False

Back 19

True

Front 20

Which one of the following databases is considered a functional database?

multimedia database
object-oriented database
operational database
distributed database

Back 20

operational database

Front 21

What is the smallest element of data in a database?

entity
field
record
file

Back 21

field

Front 22

A modern database is similar to which item of office furniture or equipment?

filing cabinet
desk
typewriter
copying machine

Back 22

filing cabinet

Front 23

A popular form of hybrid database combines

relational and object-oriented data models.
distributed and multimedia data models.
flat file and distributed data models.
object-oriented and multimedia data models.

Back 23

relational and object-oriented data models.

Front 24

What is the first step in planning a database?

designing a user-friendly interface
setting up reporting capabilities
finding a way to prevent erroneous data from entering the database
establishing the field-record-file structure

Back 24

establishing the field-record-file structure

Front 25

Compared with noncomputerized offices, electronic offices tend to generate

no paper documents.
less paper documents.
more paper documents.
about the same amount of paper documents.

Back 25

more paper documents.

Front 26

Which type of information system is designed to deliver products quicker, cheaper, and with fewer errors?

decision support system
management information system
distribution management system
office information system

Back 26

distribution management system

Front 27

Microsoft founder Bill Gates is interested in developing software that

audits e-voting systems and prevents vote manipulation.
streamlines delivery of books and other printed material.
helps PC and Inter users to derive knowledge from information.
provides the structure for household information systems.

Back 27

helps PC and Inter users to derive knowledge from information.

Front 28

Compatibility refers to the ability to link with other programs and devices.

True
False

Back 28

False

Front 29

Companies want to reduce the size of their inventories because they save money on

the cost of raw materials.
office personnel.
shipping costs.
storage costs.

Back 29

storage costs.

Front 30

How long does the support stage last?

until a new information system is proposed and developed
until all users have been trained
for several years
until the information system is operating smoothly

Back 30

until a new information system is proposed and developed

Front 31

Which one of the following comes first in developing an information system?

Prepare a needs analysis.
Develop the functional specification.
Identify technical support requirements.
Train the users.

Back 31

Prepare a needs analysis.

Front 32

What does a support contract specify?

which operating system will be used
what the information system must be able to do
when deliverables will be received
who is responsible for training new users

Back 32

who is responsible for training new users

Front 33

What is a characteristic of newer information systems?

merged databases
manual input
compartmentalized information
improved speed

Back 33

merged databases

Front 34

In contrast to computer-aided manufacturing, computer-integrated manufacturing

is a smaller information system.
involves the direct use of computerized systems to manufacture products.
focuses on the company as a whole.
makes information available only to assembly line workers.

Back 34

focuses on the company as a whole.

Front 35

A support contract ensures that system integrators will be available for on-site troubleshooting after the new system has received final approval.

True
False

Back 35

True

Front 36

Software packages that automate the design and development of an information system are called

CASE tools.
expert systems.
turnkey solutions.
database editors.

Back 36

CASE tools.

Front 37

When does user training normally take place?

at the same time as system testing
when the project team is assembled
during the support stage
before prototype development

Back 37

at the same time as system testing

Front 38

Which type of information system provides reports on quarterly earnings, cash flow, and other transactions to help a company improve productivity and profitability?

distribution management system
office information system
management information system
factory automation system

Back 38

management information system

Front 39

What was the “killer application” that drove early PC sales into the millions?

games and entertainment
spreadsheets
database management
word processing

Back 39

spreadsheets

Front 40

Which one of the following is a substep of planning an information system?

Train users.
Write a design specification.
Develop a prototype.
Assemble a project team.

Back 40

Assemble a project team.

Front 41

Hasso Plattner is the German counterpart to

Timothy Berners-Lee.
Bill Gates.
Linus Torvalds.
Steven Jobs.

Back 41

Bill Gates.

Front 42

Which one of the following is a type of artificial intelligence?

data modeling
transactional processing
expert systems
online analytical processing

Back 42

expert systems

Front 43

An information system is used to store demographic data for the U.S. Census Bureau.

True
False

Back 43

True

Front 44

What system would a petroleum refinery use to monitor production?

executive support system
factory automation system
distribution management system
management support system

Back 44

factory automation system

Front 45

When did the first computerized information systems appear?

1950s
1960s
1970s
1980s

Back 45

1950s

Front 46

Which one of the following is an evolving technology for examining masses of data?

spreadsheets
data modeling
online analytical processing
expert systems

Back 46

online analytical processing

Front 47

What is the purpose of a feasibility study?

to investigate different information systems
to determine how difficult a project might be to complete
to estimate how long a project will take to complete
to decide which supplier would be best for the project

Back 47

to determine how difficult a project might be to complete

Front 48

An example of an information system is

an MBA.
an ALS.
a GPA.
an ATM.

Back 48

an ATM.

Front 49

What does RAD stand for in information system technology?

reliable accessible database
rare advantage development
rapid application development
risk advantage database

Back 49

rapid application development

Front 50

Which factory automation system combines data tracking and data modeling to give a picture of how well a factory is operating?

computer-assisted manufacturing
computer-aided manufacturing
statistical quality control
computer-integrated manufacturing

Back 50

statistical quality control

Front 51

A major category of e-commerce is machine-to-machine (M2M) electronic commerce.

True
False

Back 51

False

Front 52

A passport is a Web site that offers entry into a variety of Internet services.

True
False

Back 52

False

Front 53

The supply chain is also known as a(n)

chain of command.
value chain.
events chain.
reaction chain.

Back 53

value chain.

Front 54

Which one of the following is not part of the terms of sale?

item prices
policy on transaction security
shipping costs
return policy

Back 54

policy on transaction security

Front 55

In the first quarter of 2006, retail e-commerce sales topped

$2.5 million.
$25 million.
$2.5 billion.
$25 billion.

Back 55

$25 billion.

Front 56

What is a Web site called where business activities or transactions occur?

a storefront
a venue
a portal
a virtual store

Back 56

a venue

Front 57

What is the percentage of households that is expected to bank online by 2010?

32 percent
42 percent
52 percent
62 percent

Back 57

62 percent

Front 58

What are two popular applications of peer-to-peer networking?

auctions and music distribution
car- and home-buying services
entertainment and fashion
banking and travel services

Back 58

auctions and music distribution

Front 59

Which of the following has not been an outcome of the Napster case?

music downloads at reasonable prices
widespread use of MP3 digital music compression technology
free sharing of music over the Internet
a ban on distributing copyrighted songs on the Internet

Back 59

free sharing of music over the Internet

Front 60

How can you tell if an online shopping site is secure?

It includes an “s” after the “http” in the URL.
It displays a pop-up notice.
It displays an FBI seal of approval.
It shows your social security number as asterisks.

Back 60

It includes an “s” after the “http” in the URL.

Front 61

Which Internet structure uses tunneling?

virtual private network
company Web site
intranet
extranet

Back 61

virtual private network

Front 62

Ultimately, in a free market economy a business survives only if it produces high-quality, in-demand products or services and

keeps its costs low.
provides coupons free to customers.
keeps detailed employee records.
advertises its products in the national media.

Back 62

keeps its costs low.

Front 63

What initiates an electronic transfer of funds from a checking account to a merchant?

credit card
debit card
e-check
digital cash

Back 63

e-check

Front 64

What is a general term that refers to any transfer of money over the Internet?

electronic funds transfer
online payment transfer
financial electronic data interchange
electronic money exchange

Back 64

electronic funds transfer

Front 65

Encryption is the process of converting readable information into

cybertext.
ciphertext.
plaintext.
hypertext.

Back 65

ciphertext.

Front 66

Which one of the following increases the efficiency of online shopping most significantly?

encryption keys
Web browsers
cookies
portals

Back 66

cookies

Front 67

In B2B e-commerce, the need to depend on many outside companies to help create, market, and distribute a business’s product is called

independence.
interdependence.
dependence.
intradependence.

Back 67

interdependence.

Front 68

Pierre Omidyar’s search for Pez dispensers led to the creation of

MySimon.
eBay.
Lycos.
Expedia.

Back 68

eBay.

Front 69

In establishing an e-tailer Web site, an e-tailer should give highest priority to

designing pages so they download quickly.
balancing use of text, graphics, color, and animation.
creating links to other sites.
making sure pages print correctly.

Back 69

designing pages so they download quickly.

Front 70

What is tunneling?

embedding a chip in a cell phone’s subscriber information module
programming computers to communicate directly with each other
using underground cables to communicate with other businesses
sending data via another network’s connections

Back 70

sending data via another network’s connections

Front 71

What type of encryption software stores a user’s personal, credit card, and shipping information?

electronic wallet
smart card
electronic signature
digital cash

Back 71

electronic wallet

Front 72

An encryption key is actually a formula that uses a code.

True
False

Back 72

True

Front 73

Which one of the following is a clue that an online shopping site does not represent a legitimate business?

The URL changes as you navigate through the site.
You have to log onto the site.
There is no chance to change your mind before finalizing a purchase.
You have to click to an information page to find detailed information about a product.

Back 73

There is no chance to change your mind before finalizing a purchase.

Front 74

What can URL-Promoter help an e-tailer do?

link with other sites
register for a domain name
process payments
sign up with search engines

Back 74

sign up with search engines

Front 75

What is the bank’s role in the above process?

The bank decodes the customer’s financial information.
The bank underwrites the customer’s order in the event she is unable to pay.
The bank sends the customer money to pay for the order.
The bank verifies the customer’s financial information.

Back 75

The bank verifies the customer’s financial information.