Final Study Guide

Name:

Final Study Guide

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

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

You must pay for a domain name.

You may use an analog modem even if your phone service is digital.

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

Cloud computing is the term given to analyzing cloud patterns and with the help of the computer predicting the weather.

Bit-Torrent uses P2P technology.

Most firewall software is preconfigured to block only unnecessarily open ports targeted by hackers.

The two applications shown in the accompanying figure are examples of Web browser software.

Scripts are designed to replace normal HTML.

10.

An ActiveX control is a full-fledged program, which gives it the potential to include a routine that alters or deletes files from your hard drive.

11.

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

12.

Netiquette is online jargon for Internet etiquette.

13.

Popular digital audio formats include AAC, MP3, and Wave.

14.

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

15.

With vector graphics, like the one found in the accompanying figure, objects may be layered over other objects.

16.

CDs with copy protection cannot be duplicated and music that is ripped to another format does not play back correctly.

17.

The accompanying figure represents the basic flow of information in an expert system and summarizes its capabilities.

18.

In the accompanying figure, the Student item represents a data store.

19.

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.

20.

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

21.

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

22.

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

23.

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

24.

An index has no bearing on the physical sequence of records on disk.

25.

An encrypted database can be queried quickly.

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

26.

There are estimated to be more than ____ users of the Internet.

a.	1.5 million	c.	1.5 trillion
b.	1.5 billion	d.	100 million

27.

In the accompanying figure, C points to ____.

a.	an ISP	c.	the Internet backbone
b.	an NSP	d.	an Internet router

28.

An address on the Web is called a(n) ____.

a.	domain name	c.	URL
b.	ISP	d.	NAP address

29.

____ is a valid top-level domain.

a.	.ca	c.	.gog
b.	.can	d.	.aol

30.

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

31.

The rate of data that is transmitted from your computer to the Internet is ____.

a.	downstream speed	c.	download speed
b.	upstream speed	d.	upload speed

32.

In the accompanying figure, the type of signal represented by A is a(n)____.

a.	digital signal	c.	sine signal
b.	analog signal	d.	cosine signal

33.

In the accompanying figure, the type of signal represented by B is a(n)____.

a.	digital signal	c.	sine signal
b.	analog signal	d.	cosine signal

34.

Some ISDN providers offer a service called ____, which remains connected to an ISP as long as the computer and terminal adapter are on.

a.	AO/DI	c.	VDSL
b.	DSL	d.	HDSL

35.

A ____ is a device that connects a computer to a telephone line and converts computer data signals into signals compatible with DSL.

a.	DSL filter	c.	DSL modem
b.	DSL converter	d.	DSL adapter

36.

____ currently offers the fastest Internet access speeds.

a.	ISDN	c.	Satellite
b.	DSL	d.	Cable

37.

An Ethernet-compatible network standard designed as IEEE 802.16 is ____.

a.	WiFi	c.	WiMAX
b.	WiLAN	d.	WiMAN

38.

Portable Internet access includes all of the following EXCEPT ____.

a.	WiFi	c.	portable wireless
b.	portable satellite	d.	cellular

39.

The ability to easily move your Internet service from one location to another is considered ____ Internet service.

a.	mobile	c.	moving
b.	portable	d.	cellular

40.

____ is an up-and-coming standard destined to be deployed by ISPs and cell phone carriers to allow seamless hand-offs between one tower and another.

a.	WiMAX	c.	Portable WiMAX
b.	Mobile WiMAX	d.	Mobile WiFi

41.

____ is a 3G technology that works on GSM and GPRS cellular networks.

a.	EDGE	c.	HSUPA
b.	EV-DO	d.	all of the above

42.

____ is a 3G technology developed by Qualcomm and currently deployed by Alltel, Sprint, and Verizon.

a.	EDGE	c.	HSUPA
b.	EV-DO	d.	none of the above

43.

A communication protocol that provides Internet access from handheld devices is ____.

a.	WAP	c.	HAP
b.	WIP	d.	HIP

44.

The disadvantage of WAP-enabled devices is their ____.

a.	access speed	c.	battery life
b.	screen size	d.	all of the above

45.

You can use a service called ____ to reformat Web pages to fit on a small screen.

a.	Squizit	c.	Kweezer
b.	Skweezer	d.	Squeezer

46.

For instant messaging, ____ are the people in a participant's list who are currently online.

a.	buddies	c.	clients
b.	pals	d.	friends

47.

Messaging systems that require client software includes ____.

a.	Apple iChat	c.	Yahoo! Messenger
b.	AOL Instant Messenger	d.	all of the above

48.

The accompanying figure is a screenshot of FileZilla, in which the file to be ____ is indicated by box B.

a.	uploaded	c.	reloaded
b.	downloaded	d.	remastered

49.

____ is a file sharing protocol that distributes the role of the file server across a collection of dispersed computers.

a.	ftp	c.	P2P
b.	http	d.	BitTorrent

50.

A group of computers temporarily networked to download a file is a ____.

a.	swarm	c.	leech
b.	seed	d.	choker

51.

____ are intended to work on LANs to monitor and direct packets being transported from one device to another.

a.	Routers	c.	Filters
b.	Gateways	d.	Firewalls

52.

The accompanying figure represents a Virtual Private Network. In this figure, D points to a(n) ____.

a.	encrypted channel	c.	VPN channel
b.	Internet connection	d.	Internet channel

53.

The accompanying figure represents a Virtual Private Network. In this figure, E points to a(n) ____.

a.	Server	c.	Internet channel
b.	Internet	d.	ISP

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.

54.

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.

55.

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

56.

A(n) ____ is a collection of related information organized and formatted so it can be accessed using software called a browser.

a.	Web site	c.	podcast
b.	Internet	d.	tag

57.

When using an application like the one shown in the accompanying figure, you can access a Web page by clicking a(n) ____ or by typing a URL.

a.	cookie	c.	link
b.	key	d.	tunnel

58.

A ____ is a collaborative Web site that can be accessed and edited by anyone who wants to contribute to it.

a.	page	c.	wiki
b.	link	d.	manual

59.

The process of accessing Web sites is sometimes referred to as ____.

a.	linking	c.	texting
b.	surfing	d.	messaging

60.

For HTTP, ____ usually are associated with port 80 on the client and server.

a.	exchanges	c.	sockets
b.	methods	d.	actions

61.

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

62.

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

63.

Applications written in the Java programming language are called Java ____.

a.	frames	c.	applets
b.	servlets	d.	fragments

64.

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

65.

Search engine ____ software is designed to pull keywords from a Web page and store them in a database.

a.	indexer	c.	archive
b.	crawler	d.	tracker

66.

In addition to using search engines, you can also find Web-based information using a(n) ____ engine that searches a series of other search engines and compiles the search results.

a.	compiled	c.	metasearch
b.	stuffed	d.	secure

67.

A ____ ad overlays the content on a Web page, sometimes obscuring it until you click the ad or its timer expires and the ad disappears.

a.	banner	c.	pop-up
b.	hover	d.	click-through

68.

Which of the following technologies are used to create a secure connection between a client computer and a Web site?

a.	SSL	c.	S-HTTP
b.	TLS	d.	all of the above

69.

To use POP e-mail you must install e-mail ____ software on your computer.

a.	server	c.	resource
b.	database	d.	client

70.

____ 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

71.

____ schemes redirect users to fake sites by poisoning a domain name server with a fake IP address.

a.	Filtering	c.	Proxy
b.	Hypertexting	d.	Pharming

Case-Based Critical Thinking Questions
Case 7-1

Mark is interested in Internet e-commerce security issues. His friend Amelia runs a small B2C site that sells vintage clothing. He discusses the topic with Amelia and he learns about ActiveX controls, and how browsers and Web servers communicate with each other.

72.

To identify the creator of an ActiveX control, Amelia tells Mark that he should look at the control’s ____.

a.	digital receipt	c.	digital certificate
b.	ActiveX certificate	d.	ActiveX applet

Case-Based Critical Thinking Questions
Case 7-2

Jessica likes to participate in B2C e-commerce, but recently has had a number of friends who have had problems shopping online. She wonders if it is safe to shop online, and just how much she is compromising her privacy by doing so. Jessica is justifiably worried about the security of the personal information and credit card information she regularly supplies while shopping on the Web. In addition, she knows that merchants who market goods and services over the Internet sometimes secretly gather information and provide it to advertisers or other interested parties.

73.

Jessica has an always-on connection to the Internet. She has read about IP addresses, and knows that some Web sites can track them. She would like to surf the Internet anonymously to protect her privacy. How can she do this?

a.	Use antivirus software	c.	Run a Java applet
b.	Install a Web bug	d.	Use an anonymous proxy service

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.

74.

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

75.

What is the approximate size of a 32 MB CD track when it is in MP3 format?

a.	1 MB	c.	16 MB
b.	3 MB	d.	32 MB

76.

Which of the following is supported by the iPod?

a.	MIDI	c.	WMA
b.	WAV	d.	all of the above

77.

A ____ graphic is composed of a grid of dots.

a.	roster	c.	bitmap
b.	vector	d.	none of the above

78.

One way to transfer photo data from a camera directly to a computer is via ____.

a.	e-mail	c.	driver wires
b.	FireWire ports	d.	printer cables

79.

If your computer and your camera have ____ ports, you can connect a cable between these two ports to transfer the photo data.

a.	memory	c.	FireWire
b.	Flash	d.	adapter

80.

A resolution of 1600 x 1200 could also be expressed as ____ megapixels.

a.	.19	c.	19
b.	1.9	d.	190

81.

You have just decreased the number of pixels, resolution and file size of your graphic by selecting a portion of the image. What have you done to your graphic?

a.	You have zoomed in on your graphic.	c.	You have pixelated your graphic.
b.	You have cropped your graphic.	d.	You have rastered your graphic.

82.

A True Color or 24-bit bitmap can produce a maximum of ____ colors.

a.	16.7 million	c.	256
b.	10 million	d.	2

83.

The ____ bitmap graphics file format was designed to improve on the GIF format, compresses bitmap data without losing any data, and supports trillions of colors.

a.	TIFF	c.	JPEG
b.	PCX	d.	PNG

84.

You plan to create a cartoon-like image of a computer to be used in a flyer for your school’s computer lab. What type of graphic would you most likely use?

a.	A vector graphic	c.	A bitmap graphic.
b.	A scanned graphic	d.	A metafile graphic

85.

One clue that an image might be a ____ graphic is a flat, cartoon-like quality.

a.	bitmap	c.	vector
b.	raster	d.	pixelated

86.

Vector graphics software is sometimes referred to as ____ software.

a.	digitizing	c.	drawing
b.	dithering	d.	scaling

87.

Graphics files that contain both bitmap and vector data are called ____.

a.	raster files	c.	pixelated files
b.	gradient files	d.	metafiles

88.

Today’s ____ editing simply requires a computer hard disk and video editing software.

a.	linear	c.	nonlinear
b.	extrapolated	d.	rated

89.

____ is a popular format for Web-based video that requires Adobe Flash Player.

a.	RealMedia	c.	QuickTime Movie
b.	Flash Video	d.	Audio Video Interleave

90.

____ is the process of recording a broadcast so that it can be played back at a more convenient time.

a.	Time shifting	c.	Program
b.	Format	d.	Delay

91.

____ shifting is the process of converting media files from a format suitable to one device to a format suitable for a different kind of device.

a.	Device	c.	Player
b.	Format	d.	Plug-in

92.

Which of the following is NOT a copy protection technology?

a.	Copy Manager	c.	Cactus Data Shield
b.	Extended Copy Protection	d.	Copy Control

93.

Copy ____ management is a digital watermark that specifies the number of times a content stream can be duplicated.

a.	variety	c.	iteration
b.	number	d.	generation

94.

____ 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

95.

Originally, the application in the accompanying figure used a technology called FairPlay, which stored music in a protected ____ format.

a.	EPM	c.	CSS
b.	AAC	d.	VoIP

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.

96.

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

97.

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.

98.

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.

99.

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.

100.

Every organization has a goal or plan that is often referred to as its ____.

a.	Web site	c.	master directive
b.	mission	d.	organizing principle

101.

The purpose of ____ planning is to set incremental goals that can be achieved in a year or less.

a.	tactical	c.	operational
b.	strategic	d.	futuristic

102.

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

103.

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

104.

You are reviewing a cash-flow model of your business, which is designed to provide a numerical representation of a realistic situation. What type of tool are you using?

a.	an MIS table	c.	a decision model
b.	a decision query	d.	a neural network

105.

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

106.

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

107.

In the Planning Phase of the SDLC, a(n) ____ is assigned to analyze and develop the information system.

a.	RFP team	c.	mission team
b.	project team	d.	beta team

108.

In the PIECES framework, a ____ exists when an information system does not respond quickly enough to users, or takes too long to complete processing tasks.

a.	response problem	c.	control problem
b.	processing problem	d.	performance problem

109.

____ is a method for analyzing the time needed to complete each project task and identifying the minimum amount of time needed to complete the total project.

a.	Just in Time (JIT)
b.	Work Breakdown Structure (WBS)
c.	Program Evaluation Review Technique (PERT)
d.	Manufacturing Resource Planning (MRP)

110.

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

111.

With ____, processing tasks are shared by servers and workstations.

a.	automated processing	c.	amortized processing
b.	turnkey processing	d.	distributed processing

112.

____ might be chosen during the Design Phase of the SDLC because it requires little or no programming, and thus requires minimal development time.

a.	Industrial software	c.	Custom software
b.	Commercial software	d.	Trade software

113.

In the design phase of the SDLC, the project team ____.

a.	chooses a solution
b.	selects hardware and software
c.	designs detailed application specifications
d.	all of the above

114.

You are planning to migrate your business from its current information system to a new, more efficient information system. Your business has several branches, each of which has its own independent information processing system. What type of conversion would be appropriate in this situation?

a.	pilot conversion	c.	direct conversion
b.	parallel conversion	d.	acceptance conversion

115.

Which quality of service (QoS) metric is defined as the number of errors occurring in a particular time interval for a particular function?

a.	response time	c.	user levels
b.	accuracy	d.	capacity

116.

A ____ metric is a technique for measuring a specific characteristic by monitoring system performance and analyzing responses to user satisfaction surveys.

a.	PIECES	c.	programming
b.	quality of service (QoS)	d.	satisfaction

117.

Three key concepts ensure good quality of service from a computer system. They include all of the following EXCEPT ____.

a.	reliability	c.	availability
b.	cost	d.	serviceability

118.

Computer systems are ____ when they can be counted on to function correctly.

a.	available	c.	reliable
b.	serviceable	d.	high-performing

119.

Many organizations establish a ____ to handle end-user problems.

a.	user desk	c.	system desk
b.	help desk	d.	processing desk

120.

Antivirus software is an example of a security measure in the ____ category.

a.	detection activity	c.	preventative countermeasure
b.	deterrent	d.	corrective procedure

121.

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.

122.

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

123.

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.

124.

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

125.

In the broadest definition, a(n) ____ is a collection of information.

a.	index	c.	hierarchy
b.	database	d.	field

126.

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

127.

In the world of databases, a(n) ____ refers to a collection of data fields.

a.	record	c.	structure
b.	format	d.	index

128.

A(n) ____ is an association between data that is stored in different record types.

a.	method	c.	relationship
b.	table	d.	attribute

129.

The ____ database model uses a mesh-like structure, which allows for the definition of many-to-many relationships.

a.	hierarchical	c.	parent-child
b.	network	d.	duplex

130.

In an object database, an attribute is ____.

a.	equivalent to a record
b.	a group of objects
c.	equivalent to a field in a relational database
d.	any behavior that an object is capable of performing

131.

If a single data management tool can be used to maintain many different files and databases, it must support data ____.

a.	dependence	c.	networks
b.	independence	d.	relationships

132.

A(n) ____ allows you to create, update, and administer a relational database.

a.	XML DBMS	c.	OODBMS
b.	RDBMS	d.	ERD

133.

Database ____ software allows a remote computer or network workstation to access data in a database.

a.	client	c.	distribution
b.	server	d.	management

134.

Dynamic Web publishing relies on a program or script, referred to as a(n) ____ program, that acts as an intermediary between your browser and a DBMS.

a.	server-side	c.	XForm
b.	client-side	d.	input

135.

A CGI script can be written in all of the following EXCEPT ____.

a.	C++	c.	JavaScript
b.	Java	d.	Perl

136.

The accompanying figure shows a(n) ____ document.

a.	HTML	c.	JavaScript
b.	XML	d.	Perl

137.

____ 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

138.

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

139.

The two tables shown in the accompanying figure are ____ by the CustomerNumber field.

a.	merged	c.	split
b.	related	d.	concatenated

140.

A ____ contains the outline or general specifications for a report, including such elements as the report title, fields to include, fields to subtotal/total, and report format specifications.

a.	report matrix	c.	report converter
b.	report generator	d.	report template

141.

Which of the following is NOT a guideline for creating a template for reports?

a.	Present as much information as possible
b.	Present information in a usable format
c.	Present information in the format most appropriate for the audience
d.	Present information in a clear, unambiguous format

142.

In an SQL query, a ____ clause is used to specify the table you want to access.

a.	SELECT	c.	FROM
b.	WHICH	d.	JOIN

143.

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

144.

Which of the following SQL operators designates records that meet either one of a set of two criteria, or both?

a.	OR	c.	ALL
b.	AND	d.	NOT

145.

In SQL terminology, creating a relationship between tables is referred to as ____ tables.

a.	joining	c.	matching
b.	aligning	d.	keying

146.

Criminals have become sophisticated in the use of all of the following EXCEPT ____ to access data stored on personal computers.

a.	bots	c.	ATMs
b.	redirection	d.	keyloggers

147.

Database data that is transmitted over the Web can be encrypted using encryption technologies such as ____.

a.	SSL	c.	FTP
b.	Telnet	d.	all of the above

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.

148.

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.

149.

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.

150.

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