Name:     ID: 
 
Email: 

COMP DC2009 TEST 4 GS Chp 10-12

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

 1. 

With a(n) ____, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.
a.
DBMS
c.
QBE
b.
RMS
d.
XML
 

 2. 

____ is a common data type that includes letters, numbers, or special characters.
a.
Alpha
c.
Metric
b.
Character
d.
Text
 

 3. 

In a database, a(n) ____ is a group of related fields.
a.
table
c.
record
b.
key
d.
primary field
 

 4. 

____, a user deletes it from a file.
a.
To correct inaccurate data
b.
When new data is obtained
c.
To update old data with new data
d.
When a record no longer is needed
 

 5. 

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____ on the Annual Fee field ensures it is a value between $20.25 and $55.50.
a.
range check
c.
consistency check
b.
completeness check
d.
alphabetic/numeric check
 

 6. 

A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical.
a.
range check
c.
consistency check
b.
completeness check
d.
alphabetic/numeric check
 

 7. 

A(n) ____ is a program with which users interact that generally has a more user-friendly interface than a DBMS.
a.
back end
c.
SQL
b.
RDBMS
d.
front end
 

 8. 

An application that supports a front-end program sometimes is called the ____.
a.
back end
c.
GUI
b.
RDBMS
d.
collaborative database
 

 9. 

A(n) ____ contains data about each file in a database and each field in those files.
a.
glossary
c.
index
b.
repository
d.
table of contents
 
 
nar001-1.jpg
Figure 10-1
 

 10. 

A user of a relational database, such as that pictured in Figure 10-1, refers to a file as a ____.
a.
table
c.
row
b.
column
d.
relationship
 

 11. 

In a relational database, such as that pictured in Figure 10-1, users can set up a relationship between tables at any time, but the tables must have a common ____.
a.
record
c.
column
b.
row
d.
key
 
 
nar002-1.jpg
Figure 10-3
 

 12. 

____, as shown in Figure 10-3, is a query language that allows users to manage, update, and retrieve data.
a.
XML
c.
SQL
b.
DBMS
d.
QBE
 

 13. 

A ____ stores images, audio clips, and/or video clips.
a.
multimedia database
c.
computer-aided design (CAD) database
b.
groupware database
d.
hypertext database
 

 14. 

The advantage of a multidimensional database is that ____.
a.
there is a common query language
b.
the content of all dimensions is the same regardless of the subject
c.
it can consolidate data much faster than a relational database
d.
all of the above
 

 15. 

The data in a(n) ____ database exists in many separate locations throughout a network or the Internet.
a.
dynamic
c.
distributed
b.
remastered
d.
indexed
 

 16. 

A ____ is a malicious-logic program that hides within or looks like a legitimate program and usually is triggered by a certain condition or action.
a.
computer virus
c.
Trojan horse
b.
worm
d.
all of the above
 

 17. 

Computer viruses, worms, and Trojan horses deliver their payload on a computer when a user ____.
a.
opens an infected file
b.
runs an infected program
c.
boots the computer with an infected disk in a disk drive
d.
all of the above
 

 18. 

The computer that a hacker uses to execute a DoS or DDoS attack, known as a ____, is completely unaware that it is being used to attack other systems.
a.
cookie
c.
zombie
b.
proxy
d.
standby
 

 19. 

____ access is the use of a computer or network without permission.
a.
Unauthorized
c.
Unaudited
b.
Unidentified
d.
Biometric
 

 20. 

When users purchase software, a single-user license agreement like the one in Figure 11-5 permits users to do any of the following except ____.
a.
install the software on only one computer
b.
rent or lease the software
c.
make one copy of the software as backup
d.
give or sell the software to another individual if the software is removed from the user’s computer first
 

 21. 

When users purchase software, a single-user license agreement like the one in Figure 11-5 does not permit users to do any of the following except ____.
a.
install the software on a network
c.
make one copy of the software as backup
b.
give copies to friends and colleagues
d.
export the software
 

 22. 

____ is the process of converting readable data into unreadable characters to prevent unauthorized access.
a.
Decryption
c.
Encryption
b.
PGP
d.
Digital signing
 

 23. 

A Web site that uses encryption techniques to secure its data is known as a(n) ____ site.
a.
assigned
c.
secure
b.
master
d.
encrypted
 

 24. 

A momentary overvoltage, called a ____, occurs when the increase in power lasts for less than one millisecond (one thousandth of a second).
a.
Joule
c.
hash
b.
spike
d.
macro
 

 25. 

With a(n) ____, users choose which folders and files to include in a backup.
a.
full backup
c.
differential backup
b.
incremental backup
d.
selective backup
 

 26. 

With a three-generation backup policy, the parent is the ____.
a.
most recent copy of the file
c.
oldest copy of the file
b.
second oldest copy of the file
d.
original file
 

 27. 

To avoid items like that shown in Figure 11-1, users can sign up for ____, which is a service from an Internet service provider that blocks e-mail messages from designated sources.
a.
an anti-spam program
c.
an antivirus program
b.
e-mail encryption
d.
e-mail filtering
 

 28. 

One approach to content filtering is through a rating system of ____, which is similar to those used for movies and videos.
a.
ICRA
c.
MSN
b.
AOL
d.
BSA
 

 29. 

Content ____ is the process of restricting access to certain material on the Web.
a.
remastering
c.
indexing
b.
filtering
d.
masking
 

 30. 

A(n) ____ is an injury or disorder of the muscles, nerves, tendons, ligaments, and joints.
a.
DoS
c.
PGP
b.
ISP
d.
RSI
 

 31. 

Symptoms of a user with computer addiction include all of the following except ____.
a.
craves computer time
c.
neglects family and friends
b.
unable to stop computer activity
d.
irritable when at the computer
 

 32. 

____ measures how well a proposed system will work.
a.
Operational feasibility
c.
Schedule feasibility
b.
Technical feasibility
d.
Economic feasibility
 

 33. 

____ measures whether the established deadlines for a project are reasonable.
a.
Operational feasibility
c.
Schedule feasibility
b.
Technical feasibility
d.
Economic feasibility
 
 
nar003-1.jpg
Figure 12-5
 

 34. 

As shown in Figure 12-5, a(n) ____ is a lengthy, structured, group meeting in which users and IT professionals work together to design or develop an application.
a.
feasibility study
c.
planning phase
b.
JAD session
d.
analysis phase
 

 35. 

____ helps system developers to understand exactly how a task is performed.
a.
Reviewing documentation
c.
Research
b.
Observing
d.
A questionnaire
 

 36. 

During the ____ phase, four major activities are performed: (1) review and approve the project requests, (2) prioritize project requests, (3) allocate resources to approved projects, and (4) form a project development team for each approved project.
a.
analysis
c.
planning
b.
review
d.
development
 

 37. 

The squares on a data flow diagram are ____.
a.
data flows
c.
data stores
b.
sources
d.
processes
 

 38. 

A top level DFD (data flow diagram) identifies ____.
a.
none of the processes
c.
only the minor process
b.
all of the processes
d.
only the major process
 

 39. 

A(n) ____ is an item that can contain both data and the procedures that read or manipulate that data.
a.
object
c.
entity
b.
source
d.
actor
 

 40. 

The procedure in an object, called a(n) ____, contains activities that read or manipulate the data.
a.
UML
c.
property
b.
data store
d.
operation
 

 41. 

Although used in all types of business modeling, the ____ has been adopted as a standard notation for object modeling.
a.
UML
c.
RUP
b.
use case diagram
d.
EMR
 

 42. 

A popular methodology on the market today that uses UML is the ____ by Grady Booch, Ivar Jacobsen, and James Rumbaugh.
a.
data store
c.
TUML
b.
RUP
d.
EMR
 

 43. 

A ____ is a less formal method that uses a standard form to request information about a product or service.
a.
request for quotation (RFQ)
c.
request for proposal (RFP)
b.
request for system services (RFSS)
d.
request for information (RFI)
 

 44. 

A(n) ____ is a working model of a proposed system.
a.
adaptation
c.
mockup
b.
feasibility scheme
d.
prototype
 

 45. 

During ____, a systems analyst identifies the required programs and the relationship among each program, as well as input, output, and database specifications.
a.
storage design
c.
program design
b.
database design
d.
input and output design
 

 46. 

Integrated case products, sometimes called I-CASE or a CASE workbench, include these capabilities: ____.
a.
project repository and graphics
c.
code generators and housekeeping
b.
prototyping and quality assurance
d.
all of the above
 

 47. 

An integration test ____.
a.
verifies that each individual program works by itself
b.
verifies that all programs in an application work together properly
c.
verifies that an application works with other applications
d.
is performed by end-users and verifies that the new system works with actual data
 

 48. 

An acceptance test ____.
a.
verifies that each individual program works by itself
b.
verifies that all programs in an application work together properly
c.
verifies that an application works with other applications
d.
is performed by end-users and verifies that the new system works with actual data
 

 49. 

____ consists of running the old system alongside the new system for a specified time.
a.
Phased conversion
c.
Parallel conversion
b.
Direct conversion
d.
Pilot conversion
 

 50. 

Converting existing manual and computer files so the new system can use them is known as ____.
a.
object conversion
c.
process conversion
b.
data conversion
d.
source conversion
 



 
         Start Over