True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
Bits, bytes, fields, records, files, databases, and
networks are the different levels of data stored in a data storage hierarchy.
|
|
|
2.
|
A byte of data is the same as a
character.
|
|
|
3.
|
A field of data is a collection of
records.
|
|
|
4.
|
A collection of related fields is a
record.
|
|
|
5.
|
A file is a collection of related
fields.
|
|
|
6.
|
A field within a record that is chosen to uniquely
identify the record is the main field.
|
|
|
7.
|
Most popular database management programs provide a
graphical query-building tool, to aid users who do not have a thorough knowledge of
SQL.
|
|
|
8.
|
Filename extensions follow a period and may be up
to five letters long.
|
|
|
9.
|
Software instructions are stored in program
files.
|
|
|
10.
|
A database management system (DBMS) is a collection
of programs that controls the structure of a database and access to the data.
|
|
|
11.
|
A data dictionary is a document or a file that
stores the data definitions and descriptions of the structure of data used in the
database.
|
|
|
12.
|
The report generator is a database component that
enables recovery of the database contents after system failures.
|
|
|
13.
|
The database administrator coordinates all related
activities and needs for an organization's database.
|
|
|
14.
|
A database analyst is responsible for coordinating
and managing all the activities of a database.
|
|
|
15.
|
If a database model arranges fields or records in
related groups (like a family tree), it is an organizational chart database.
|
|
|
16.
|
In a hierarchical database, a child record is also
called a member.
|
|
|
17.
|
In a hierarchical database, there are no limits or
restrictions to the number of possible links among records.
|
|
|
18.
|
In network database terminology, a parent record is
called a member.
|
|
|
19.
|
A hierarchical database is more flexible than a
network database.
|
|
|
20.
|
In a relational database, it is important to
maintain a physical order of records or fields in a table.
|
|
|
21.
|
A hypertext database or web database is a type of
object-oriented database.
|
|
|
22.
|
An object-oriented database uses software written
in small, reusable chunks as elements within the database file.
|
|
|
23.
|
Data mining is the process of removing errors and
inconsistencies from data.
|
|
|
24.
|
Meta-data is cleansed data, which indicates the
origin of the data, the transformations it has undergone, and summary information about
it.
|
|
|
25.
|
A special database of cleansed data is a data
dictionary.
|
|
|
26.
|
Marketers use data mining tools to extract
point-of-sale databases of retail stores, which contain facts for thousands of products in hundreds
of geographic areas.
|
|
|
27.
|
The buying and selling of products and services via
computer networks is B-commerce.
|
|
|
28.
|
A B2B system allows businesses to sell goods or
services to other businesses using the internet or a private network.
|
|
|
29.
|
B-webs provide extra revenue from ancillary
services, such as financing and logistics.
|
|
|
30.
|
The marketing & sales function of an
organization builds products or provides services.
|
|
|
31.
|
Human resources department is the same as the
personnel department.
|
|
|
32.
|
The production (operations) function of an
organization oversees advertising, promotion and sales.
|
|
|
33.
|
The type of manager that is concerned with
long-range, or strategic, planning and decisions is an operations manager.
|
|
|
34.
|
The type of manager that makes tactical decisions
to implement the strategic goals of an organization is a top manager.
|
|
|
35.
|
A schematic showing the hierarchy of formal
relationships among an organization's employees is an organization chart.
|
|
|
36.
|
The type of manager that makes operational
decisions by following well-defined set of routine procedures is a middle-level
manager.
|
|
|
37.
|
An office automation system combines various
technologies such as voice mail, fax machines, and others in order to reduce the manual
labor.
|
|
|
38.
|
A computer-based information system that keeps
track of the transactions needed to conduct business is a transaction processing
system.
|
|
|
39.
|
Management information system uses data recorded by
TPS as input into programs that produce routine reports as output.
|
|
|
40.
|
A decision support system is a computer-based
information system that provides a flexible tool for analysis and helps managers to focus on the
future.
|
|
|
41.
|
A set of interactive computer programs that helps
users solve problems without the assistance of a human expert is an authority
system.
|
|
|
42.
|
Automated Virtual Representatives (vReps) offer
computer-generated images that answer customer questions in real time, using natural
language.
|
|
|
43.
|
An expert system is an interactive computer program
used in solving problems that would otherwise require the assistance of a human
expert.
|
|
|
44.
|
Artificial intelligence (AI) is a group of related
technologies used for stem cell research.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
45.
|
A field is a unit of data consisting of a
collection of ________.
a. | characters | c. | records | b. | tables | d. | files |
|
|
|
46.
|
What is one byte of data also
called?
a. | character | c. | record | b. | field | d. | file |
|
|
|
47.
|
Which of the following is NOT a level of the data
storage hierarchy?
a. | bit | c. | record | b. | byte | d. | network |
|
|
|
48.
|
A record is a collection of related
________.
a. | characters | c. | fields | b. | tables | d. | files |
|
|
|
49.
|
A file is a collection of related
________.
a. | characters | c. | fields | b. | tables | d. | records |
|
|
|
50.
|
What is a field that is chosen to uniquely identify
a record called?
a. | main field | c. | high field | b. | super field | d. | key field |
|
|
|
51.
|
Filename extensions, follow a period and may be up
to ________ letters in length.
|
|
|
52.
|
If a file contains software instructions, then it
is a ________ file.
a. | statistics | c. | data | b. | program | d. | key |
|
|
|
53.
|
In a database management system, the ________ is a
document or file that stores the data definitions and descriptions of the structure of data used in
the database.
a. | access security | c. | report generator | b. | data dictionary | d. | DBMS utility |
|
|
|
54.
|
What are programs that help a database to be
maintained, by creating, editing, and deleting data, records, and files?
a. | access security | c. | report generator | b. | data dictionary | d. | DBMS utilities |
|
|
|
55.
|
Which of the following is a program that produces
an on-screen or printed document from all or part of a database?
a. | access security | c. | report generator | b. | data dictionary | d. | DBMS utilities |
|
|
|
56.
|
The person who coordinates all activities and needs
for an organization's database is the ________.
a. | database administrator | c. | database analyst | b. | database manager | d. | database master |
|
|
|
57.
|
Which of the following is NOT a task performed by
the database administrator (DBA)?
a. | Determining user access privileges | c. | Installing hardware | b. | Assisting in
establishing priorities for requests | d. | Developing user
documentation |
|
|
|
58.
|
Which type of database model arranges fields or
records in related groups whereby each child record can have only one parent
record?
a. | hierarchical database | c. | distributed
database | b. | network database | d. | object-oriented database |
|
|
|
59.
|
What is a parent record called in network database
terminology?
a. | guest | c. | member | b. | owner | d. | resident |
|
|
|
60.
|
What is a child record called in network database
terminology?
a. | guest | c. | member | b. | owner | d. | resident |
|
|
|
61.
|
Which type of database model is similar to a
hierarchical database, but allows each child record to have more than one parent
record?
a. | hierarchical database | c. | distributed database | b. | network
database | d. | object-oriented database |
|
|
|
62.
|
Which type of database model connects data in
different files through the use of a key field?
a. | hierarchical database | c. | relational database | b. | network
database | d. | object-oriented database |
|
|
|
63.
|
Which of the following is NOT an example of
database terminology?
a. | tuples | c. | qualities | b. | attributes | d. | relations |
|
|
|
64.
|
Which of the following clauses is NOT a component
of structured query language (SQL)?
a. | SELECT...FROM statement | c. | ORDER BY clause | b. | WHERE
clause | d. | WHEREBY clause |
|
|
|
65.
|
Which type of database uses software written in
small, reusable chunks as elements within database files?
a. | hierarchical database | c. | distributed database | b. | network
database | d. | object-oriented database |
|
|
|
66.
|
Which of the following is the computer-assisted
process of sifting through and analyzing vast amounts of data to extract meaning and discover new
knowledge?
a. | data mining | c. | data
warehousing | b. | e-commerce | d. | business-to-business systems |
|
|
|
67.
|
What is the process of removing errors and
inconsistencies from data called?
a. | data cleansing | c. | data buffing | b. | data polishing | d. | data
manipulation |
|
|
|
68.
|
What describes contents of a data
warehouse?
a. | omega data | c. | data area | b. | meta data | d. | warehouse data |
|
|
|
69.
|
What is a special database of cleansed data
called?
a. | data warehouse | c. | shared database | b. | relational database | d. | data area |
|
|
|
70.
|
What data mining (DM) tool is used to catalog
galaxies?
a. | SKICAT | c. | GALAXOR | b. | IDIS | d. | query-and-report |
|
|
|
71.
|
The buying and selling of products and services via
computer networks is called ________.
a. | data mining | c. | commerce | b. | e-commerce | d. | data
warehousing |
|
|
|
72.
|
What enables businesses to sell goods or services
to other businesses using the internet or a private network?
a. | DBMS | c. | data mining | b. | B2B | d. | mirroring |
|
|
|
73.
|
Which department of an organization makes products
or provides services?
a. | human resources | c. | production (operations) | b. | marketing &
sales | d. | research &
development |
|
|
|
74.
|
Which department of an organization recruits
people?
a. | human resources | c. | production (operations) | b. | marketing &
sales | d. | research &
development |
|
|
|
75.
|
Which function of an organization oversees
advertising, promotion, and sales?
a. | human resources | c. | production (operations) | b. | marketing &
sales | d. | research &
development |
|
|
|
76.
|
A schematic showing the hierarchy of formal
relationships among an organization's employees is a(n) ________.
a. | management chart | c. | management tree | b. | organization chart | d. | relationship
chart |
|
|
|
77.
|
The ________manager is concerned with long-range,
or strategic planning and decisions.
a. | operational | c. | top | b. | tactical | d. | principal |
|
|
|
78.
|
The ________ manager makes tactical decisions to
implement the strategic goals of an organization.
a. | operational | c. | top | b. | tactical | d. | principal |
|
|
|
79.
|
The ________ manager makes operational decisions by
following a well-defined set of routine procedures.
a. | operational | c. | top | b. | tactical | d. | principal |
|
|
|
80.
|
Which of the following statements about managers is
incorrect?
a. | Top-level managers make strategic
decisions. | c. | Operational managers make analytical
decisions. | b. | Lower management
makes operational decisions. | d. | Middle-level managers make tactical
decisions. |
|
|
|
81.
|
In a business organization, a recorded event having
to do with routine business activities is a ________.
a. | model | c. | operation | b. | transaction | d. | contract |
|
|
|
82.
|
A system that combines various technologies such as
voice mail, fax machines, and others in order to reduce the manual labor is a(n) ________
system.
a. | office processing | c. | decision support | b. | office automation | d. | executive
support |
|
|
|
83.
|
A computer-based information system that keeps
track of the transactions needed to conduct business is a(n) ________ system.
a. | transaction processing | c. | executive support | b. | office automation | d. | decision
support |
|
|
|
84.
|
A computer-based information system that uses data
recorded by transaction processing system as input into programs that produce routine reports as
output is a(n) ________ system.
a. | office automation | c. | management information | b. | executive
support | d. | decision
support |
|
|
|
85.
|
If you were in operational (lower) management,
which type of computer-based information system would you use?
a. | transaction processing system
(TPS) | c. | decision support system (DSS) | b. | management information system (MIS) | d. | executive support
system (ESS) |
|
|
|
86.
|
A computer-based information system that provides a
flexible tool for analysis and helps managers focus on the future is a(n) ________
system.
a. | office automation | c. | executive support | b. | decision support | d. | transaction
processing |
|
|
|
87.
|
An easy-to-use decision support system that
specifically supports strategic decision-making is a(n) ________ system.
a. | executive support | c. | decision support | b. | office automation | d. | trasnaction
processing |
|
|
|
88.
|
If you were in top management, which type of
computer-based information system would you use?
a. | transaction processing system
(TPS) | c. | executive support system
(ESS) | b. | management information system
(MIS) | d. | decision support system (DSS) |
|
|
|
89.
|
A set of interactive computer programs that help
users solve problems that would otherwise require the assistance of a human expert is a(n) ________
system.
a. | expert | c. | professional | b. | authority | d. | influence |
|
|
|
90.
|
What is the software that controls the structure of
a database and access to the data?
a. | office suite | c. | spreadsheet | b. | database management system | d. | database suite |
|
|
|
91.
|
What program is used to screen out dangerous
commercial airline passengers?
a. | CAPPS II | c. | report generator | b. | TUI | d. | MVS |
|
|
|
92.
|
The right of a person to avoid disclosure of his or
her personal information is called ________.
a. | secrecy | c. | personality | b. | privacy | d. | rationality |
|
|
|
93.
|
The crime in which thieves hijack a person's
name and identity to gain money or purchase goods is called ________.
a. | theft of privacy | c. | theft
of rationality | b. | theft of
identity | d. | theft of secrecy |
|