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.
|
|
|
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 |
|
|
|
 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 |
|
|
|
 Figure 10-3
|
|
|
12.
|
____, as shown in Figure 10-3, is a query language that allows users to manage,
update, and retrieve data.
|
|
|
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.
|
|
|
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.
|
|
|
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 |
|
|
|
 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 |
|