Name:     ID: 
 
Email: 

Final Study Guide

True/False
Indicate whether the statement is true or false.
 

 1. 

The octets in an IP address correspond to a Web site address.
 

 2. 

You can use a USB port to connect your wireless modem card to your laptop.
 

 3. 

Bit-Torrent uses P2P technology.
 

 4. 

A C2C e-commerce transaction occurs when a company sells a product or service to a customer over a network.
 

 5. 

An infrared port will transfer a digital photo from a camera to a computer faster than a serial, USB, or FireWire port.
 

 6. 

Direct conversion avoids some of the risk of parallel conversion because the old system remains in service while some or all of the new system is activated.
 

 7. 

The maintenance phase of the SDLC is the least expensive part of the cycle.
 

 8. 

The hyperlink data type is used to store data that can have one of two values.
 

 9. 

Sorted tables typically produce slower queries and updates than unsorted tables.
 

 10. 

Queries within an unsorted database are slow because each record must be looked at sequentially.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 11. 

An address on the Web is called a(n) ____.
a.
domain name
c.
URL
b.
ISP
d.
NAP address
 

 12. 

The elapsed time for data to make a round trip from point A to point B and back is called ____.
a.
speed
c.
mHz
b.
latency
d.
access time
 

 13. 

A communication protocol that provides Internet access from handheld devices is ____.
a.
WAP
c.
HAP
b.
WIP
d.
HIP
 

 14. 

A group of computers temporarily networked to download a file is a ____.
a.
swarm
c.
leech
b.
seed
d.
choker
 
 
Case-Based Critical Thinking Questions
Case 6-1

Tom is currently using dial-up for his Internet connection but he believes it is too slow for his needs and ties up his phone line. He is looking for an alternative and has come to you for help.
 

 15. 

Tom wants to know which of the services uses his existing telephone lines. You tell him ____.
a.
DSL
c.
both a and b
b.
ISDN
d.
neither a or b
 
 
Case-Based Critical Thinking Questions
Case 6-3

Harry is concerned about Internet security. He knows very little about the subject but does know it has been in the news a great deal lately. He needs your advice.
 

 16. 

Harry’s grandson has been coming to his house and downloading music. His grandson turned “file sharing” on. He is concerned this causes security problems. He should ____.
a.
deactivate it when not needed
c.
get an additional firewall
b.
get anti-sharing software
d.
forget it and not worry
 

 17. 

The process of accessing Web sites is sometimes referred to as ____.
a.
linking
c.
texting
b.
surfing
d.
messaging
 

 18. 

HTTP is classified as a ____ protocol because it maintains no record of previous interactions and handles each request based entirely on information that comes with it.
a.
status
c.
server
b.
port-based
d.
stateless
 

 19. 

A(n) ____ is a series of instructions that is embedded directly into an HTML document that instruct the browser to carry out specific actions or to respond to specific user actions.
a.
HTML tag
c.
podcast
b.
HTML script
d.
cookie
 

 20. 

A(n) ____ is a compiled computer program that can be referenced from within an HTML document, downloaded, installed on your computer, and executed within the browser window.
a.
JAVA applet
c.
HTML tag
b.
ActiveX control
d.
HTML form
 

 21. 

To use POP e-mail you must install e-mail ____ software on your computer.
a.
server
c.
resource
b.
database
d.
client
 

 22. 

____ e-mail stores your e-mail messages on a server, where you have less control over who can access them.
a.
POP
c.
SMTP
b.
IMAP
d.
Web-based
 
 
Case-Based Critical Thinking Questions
Case 7-3

Melissa has decided to obtain an e-mail account. Although she plans to use the e-mail account to communicate with her many friends, her main purpose in establishing it is to aid in the search for a job. She has a list of e-mail addresses for a group of potential employers.  Melissa intends to e-mail her resume, along with a general message, to each of them. She will use the same message for all recipients.
 

 23. 

Melissa wants to save some time by e-mailing her resume to all of the human resources offices of her target employers at one time.  She does not want the employers knowing that she is e-mailing multiple recipients the same e-mail message at the same time. Which e-mail feature should she use?
a.
Bcc
c.
Reply All
b.
Cc
d.
To
 

 24. 

Vector graphics software is sometimes referred to as ____ software.
a.
digitizing
c.
drawing
b.
dithering
d.
scaling
 

 25. 

____ is a well-known DRM technology designed to encrypt and control the use of content stored on DVDs.
a.
DeCSS
c.
CSS
b.
AACS
d.
Revocation
 
 
Case-Based Critical Thinking Questions
Case 8-2

Anita fancies herself to be an artist on the computer. She has drawn a stylized image of the Parthenon using a series of long and rectangular objects for the columns, a triangular object for the roof, and a circular object for the sun. She layered the objects so that the roof object is layered in front of the columns and sun. She likes having a great deal of flexibility in arranging and editing image elements.
 

 26. 

Anita has created files with the following names: roof, column, and sun. Which of the following file extensions would most likely be found on her files?
a.
bmp
c.
png
b.
gif
d.
wmf
 

 27. 

In addition to her computer, what other tool might Anita use to create vector graphics?
a.
A digitizing tablet.
c.
A scanner.
b.
A digital video camera.
d.
A digital camera.
 
 
Case-Based Critical Thinking Questions
Case 8-3

Digital video is often classified by its platform. Examples include desktop, Web-based, and PDA video, as well as DVD-Video. Nancy has several types of video media originating from a variety of devices, including an analog video camera, a DVR (digital video recorder), and a TV. She also has video-editing software installed on her computer.
 

 28. 

Nancy is working on a class project. She has converted a vector image of a sunset into a bitmap graphic. Nancy tried to change the color of the sun object from red to orange, but she is unable to make this change. Why?
a.
The graphic is corrupt.
b.
This is impossible because she cannot convert a vector graphic to a bitmap graphic.
c.
The graphic no longer has the qualities of a vector graphic, therefore she cannot easily change the color of one specific object.
d.
A bitmap graphic does not have the color orange.
 

 29. 

After videotaping her sister’s wedding with an analog video camera, Nancy decided to edit out some of the extra footage using her computer. She finds that, although she has connected her camera, with the videotape, to her computer she cannot access the video footage. Why?
a.
The camera must be hooked up to the printer first.
b.
The analog video footage must first be converted into a digital form.
c.
The analog video footage must be corrupt.
d.
The footage must first be converted into PDA video.
 

 30. 

As a manager, you are responsible for managing inventory. Every month you receive a low inventory report that lists stock items that have fallen below a minimum reorder point. This report is a type of ____.
a.
executive report
c.
summary report
b.
ad hoc report
d.
exception report
 

 31. 

A(n) ____ report is a customized report, generated to supply specific information not available in scheduled reports.
a.
additional
c.
ad hoc
b.
exception
d.
detailed
 

 32. 

A(n) ____ helps people make decisions by directly manipulating data, analyzing data from external sources, generating statistical projections, and creating data models of various scenarios.
a.
DSS
c.
TPS
b.
BPR
d.
MIS
 

 33. 

In an expert system, a(n) ____ engine analyzes the available data by following the rules in its knowledge base.
a.
inference
c.
reference
b.
difference
d.
expert
 

 34. 

A ____ uses bars to show the timing of development tasks as they occur over time.
a.
progress chart
c.
WBS chart
b.
Gantt chart
d.
PERT chart
 

 35. 

An enterprise-wide disaster recovery plan should do all of the following EXCEPT ____.
a.
minimize immediate damage and prevent additional losses
b.
ensure the safety of people on the premises
c.
temporarily suspend critical business operations
d.
facilitate effective coordination of recovery tasks
 
 
Case-Based Critical Thinking Questions
Case 10-1

In order to become more efficient, your company has restructured its management team. You are to convey these changes to the rest of the company.
 

 36. 

Due to the reorganization, Joe Smith will now supervise other employees, approve new products, and authorize new construction. Joe Smith is now a(n) ____.
a.
accountant
c.
manager
b.
worker
d.
vice-president
 

 37. 

Amanda Roberts is now in charge of planning the organization’s long-range goals for profitability, market share, and membership levels. She is now a(n) ____.
a.
executive manager
c.
worker
b.
mid-level manager
d.
low-level manager
 
 
Case-Based Critical Thinking Questions
Case 10-4


Jane works for a successful business that publishes a popular monthly magazine. She is responsible for ensuring that the business has the correct information systems in place to allow the business to operate efficiently and effectively.
 

 38. 

The business needs a system to track employee hours, calculate deductions and taxes, generate paychecks, and produce data for year-end reports. Which type of system should Jane investigate to meet these needs?
a.
decision support system
c.
transaction processing system
b.
management information system
d.
expert system
 

 39. 

In the broadest definition, a(n) ____ is a collection of information.
a.
index
c.
hierarchy
b.
database
d.
field
 

 40. 

Data ____ refers to the process of analyzing information in databases to discover previously unknown and potentially useful information.
a.
leading
c.
tracking
b.
mining
d.
warehousing
 

 41. 

A CGI script can be written in all of the following EXCEPT ____.
a.
C++
c.
JavaScript
b.
Java
d.
Perl
 
 
nar008-1.jpg
 

 42. 

The accompanying figure shows a(n) ____ document.
a.
HTML
c.
JavaScript
b.
XML
d.
Perl
 

 43. 

____ is a markup language that allows field tags, data, and tables to be incorporated into a Web document.
a.
HTML
c.
Java
b.
XML
d.
ASP
 

 44. 

What would be an appropriate data type to choose for a fixed-length field designed to hold a person’s name?
a.
memo data type
c.
text data type
b.
real data type
d.
logical data type
 
 
nar009-1.jpg
 

 45. 

The two tables shown in the accompanying figure are ____ by the CustomerNumber field.
a.
merged
c.
split
b.
related
d.
concatenated
 

 46. 

One of the most common database operations is to query for a particular record or group of records using the ____ command.
a.
FIND
c.
GET
b.
SELECT
d.
INSERT
 

 47. 

In SQL terminology, creating a relationship between tables is referred to as ____ tables.
a.
joining
c.
matching
b.
aligning
d.
keying
 
 
Case-Based Critical Thinking Questions
Case 11-1


Janet has been hired to design a database for a music store called WebMusic. The store sells CDs, which are to be included in the database. Janet plans to include many of the customers that visit the store in the database as well. She has designed fields for the database.
 

 48. 

The list of field names that will be used to hold WebMusic’s customer information will be defined as a template called a ____.
a.
field name
c.
record type
b.
record occurrence
d.
table
 
 
Case-Based Critical Thinking Questions
Case 11-2


In business, the goal is to choose the best data management tool to meet the needs of the business. Margaret is taking over the task of managing her company’s information needs. She knows that the best tool depends on several factors, including cost, versatility, and ease of use.
 

 49. 

Margaret inherited a previously purchased custom software package which was intended to organize product and customer databases. Unfortunately, it was never used. Margaret has to decide if the company should implement the databases using this custom software, or research the availability of basic, off-the-shelf database software. Which of the following statements best characterizes the ease of use of custom software?
a.
Easy: minimal setup required because fields are predefined
b.
Easy: uses an interface familiar to most users
c.
Difficult: has a steep learning curve
d.
Difficult: is difficult to program, but the final result may be easy to use
 
 
Case-Based Critical Thinking Questions
Case 11-4

WebMusic’s database designer, Janet, has hired an intern. She has requested that this intern create some SQL queries that would be useful to managers tracking the day-to-day operations of the store.
 

 50. 

Janet wants her intern to make some changes to the contents of records in the store’s database. Which of the following commands would the intern use?
a.
AND
c.
JOIN
b.
INSERT
d.
UPDATE
 



 
         Start Over