True/False Indicate whether the
statement is true or false.
|
|
|
1.
|
An assembly language can contribute to organizational success by providing
managers and decision makers with timely, accurate, and relevant information based on data.
|
|
|
2.
|
A database provides an essential foundation for an organization’s
information and decision support system.
|
|
|
3.
|
A database, a DBMS, and the application programs that use the data make up the
database environment.
|
|
|
4.
|
Attributes are usually selected to reflect the relevant characteristics of
entities such as employees or customers.
|
|
|
5.
|
Data modeling usually involves understanding a specific business problem and
analyzing the data and information needed to deliver a solution.
|
|
|
6.
|
ER diagrams help ensure that the relationships among the data entities in a
database are correctly structured.
|
|
|
7.
|
The tables in relational databases organize data in rows and columns,
simplifying data access and manipulation.
|
|
|
8.
|
Data anomalies often result in incorrect information, causing database users to
be misinformed about actual conditions.
|
|
|
9.
|
Databases for personal computers are most often meant for multiple users.
|
|
|
10.
|
Large mainframe computer systems can do without multiuser DBMSs.
|
|
|
11.
|
All DBMSs share some common functions, such as providing a user view, physically
storing and retrieving data in a database, allowing for database modification, manipulating data, and
generating reports.
|
|
|
12.
|
A data dictionary should not include a description of data flows, the way
records are organized, and the data-processing requirements.
|
|
|
13.
|
A DBMS can produce a wide variety of documents, reports, and other outputs that
can help organizations achieve their goals.
|
|
|
14.
|
Database systems require a skilled project manager.
|
|
|
15.
|
Data warehouses allow managers to drill down to get more detail or roll
up to take detailed data and generate aggregate or summary reports.
|
|
|
16.
|
A data model stores historical data that has been extracted from operational
systems and external data sources.
|
|
|
17.
|
Data marts bring the data warehouse concept (online analysis of sales,
inventory, and other vital business data that has been gathered from transaction processing systems)
to small and medium-sized businesses and to departments within larger companies.
|
|
|
18.
|
Data marts are most useful for large groups who want to access general
data.
|
|
|
19.
|
A data warehouse contains detailed information that can be used by an entire
company.
|
|
|
20.
|
A standardized, uniform approach to database access means that all application
programs use the same overall procedures to retrieve data and information.
|
|
|
21.
|
One of the primary disadvantages of a relational database is that it does not
allow tables to be linked.
|
|
|
22.
|
Valuable data is accurate, complete, economical, flexible, reliable, relevant,
simple, timely, verifiable, accessible, and secure.
|
|
|
23.
|
A network administrator is expected to have a clear understanding of the
fundamental business of the organization, be proficient in the use of selected database management
systems, and stay abreast of emerging technologies and new design approaches.
|
|
|
24.
|
Because distributed databases rely on telecommunications lines to transport
data, access to data can be slow.
|
Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
|
25.
|
A ____ consists of a group of programs that manipulate the database and provide
an interface between the database and its users and other application programs.
a. | flat file | c. | front-end application | b. | database management
system | d. | data
dictionary |
|
|
|
26.
|
A ____ is a skilled and trained IS professional who directs all activities
related to an organization’s database, including providing security from intruders.
a. | network administrator | c. | database administrator | b. | software
engineer | d. | system
administrator |
|
|
|
27.
|
A byte is typically ____ bits.
|
|
|
28.
|
A ____ is typically a name, number, or combination of characters that describes
an aspect of a business object
a. | field | c. | record | b. | character | d. | file |
|
|
|
29.
|
A collection of related data fields is a(n) ____.
a. | record | c. | entity | b. | database | d. | character |
|
|
|
30.
|
A collection of related records is a(n) ____.
a. | entity | c. | file | b. | attribute | d. | schema |
|
|
|
31.
|
A(n) ____ is a generalized class of people, places, or things (objects) for
which data is collected, stored, and maintained.
a. | data model | c. | relational model | b. | entity | d. | attribute |
|
|
|
32.
|
A(n) ____ is a field or set of fields in a record that identifies the
record.
a. | file | c. | record | b. | attribute | d. | key |
|
|
|
33.
|
The ____ approach to data management is an approach whereby separate data files
are created and stored for each application program.
a. | traditional | c. | object-oriented | b. | systems | d. | database |
|
|
|
34.
|
The ____ approach to data management is an approach whereby a pool of related
data is shared by multiple application programs.
a. | traditional | c. | object oriented | b. | systems | d. | database |
|
|
|
35.
|
____ is a way of organizing data in which the logical database design is altered
so that certain data entities are combined, summary totals are carried in the data records rather
than calculated from elemental data, and some data attributes are repeated in more than one data
entity to improve database performance.
a. | Data modeling | c. | Concurrency control | b. | Planned data redundancy | d. | Data mining |
|
|
|
36.
|
____ diagrams use basic graphical symbols to show the organization of and
relationships between data.
a. | Entity relationship | c. | System | b. | SQL | d. | Domain |
|
|
|
37.
|
The ____ is a database model that describes data in which all data elements are
placed in two-dimensional tables, called relations.
a. | domain model | c. | entity model | b. | query model | d. | relational
model |
|
|
|
38.
|
____ involves the manipulation of data to eliminate rows according to certain
criteria.
a. | Data mining | c. | Projecting | b. | Selecting | d. | Joining |
|
|
|
39.
|
____ involves eliminating columns in a table.
a. | Joining | c. | Projecting | b. | Selecting | d. | Data mining |
|
|
|
40.
|
____ involves combining two or more tables.
a. | Data mining | c. | Projecting | b. | Selecting | d. | Joining |
|
|
|
41.
|
A(n) ____ is a simple database program whose records have no relationship to one
another.
a. | flat file | c. | data mart | b. | data dictionary | d. | attribute |
|
|
|
42.
|
Because the DBMS is responsible for access to a database, one of the first steps
in installing and using a large database involves telling the DBMS the logical and physical structure
of the data and relationships among the data in the database for each user. This description is
called a(n) ____.
a. | record | c. | schema | b. | relation | d. | data model |
|
|
|
43.
|
A(n) ____ is a collection of instructions and commands used to define and
describe data and relationships in a specific database.
a. | machine language | c. | assembly language | b. | procedural languages | d. | data definition
language |
|
|
|
44.
|
A(n) ____ is a detailed description of all data used in the database.
a. | data mart | c. | attribute | b. | data dictionary | d. | data warehouse |
|
|
|
45.
|
____ is a method of dealing with a situation in which two or more people need to
access the same record in a database at the same time.
a. | Data modeling | c. | Predictive analysis | b. | Concurrency control | d. | Query by
Example |
|
|
|
46.
|
The ____ is responsible for defining and implementing consistent principles for
a variety of data issues, including setting data standards and data definitions that apply across all
the databases in an organization.
a. | systems administrator | c. | database administrator | b. | network
administrator | d. | project
manager |
|
|
|
47.
|
A ____ is one that directly interacts with people or users.
a. | database application | c. | proprietary application | b. | front-end
application | d. | back-end
application |
|
|
|
48.
|
A ____ interacts with other programs or applications; it only indirectly
interacts with people or users.
a. | database application | c. | proprietary application | b. | front-end
application | d. | back-end
application |
|
|
|
49.
|
A ____ is a database that holds business information from many sources in the
enterprise, covering all aspects of the company’s processes, products, and customers.
a. | data warehouse | c. | relation | b. | data mart | d. | data dictionary |
|
|
|
50.
|
____ is one aspect of business intelligence and is limited to information about
competitors and the ways that knowledge affects strategy, tactics, and operations.
a. | Competitive intelligence | c. | Counterintelligence | b. | Data synchronization | d. | Paging |
|
|
|
51.
|
The term ____ describes the steps an organization takes to protect information
sought by “hostile” intelligence gatherers.
a. | predictive analysis | c. | data cleanup | b. | data synchronization | d. | counterintelligence |
|
|
|
52.
|
A ____ holds a duplicate set of frequently used data.
a. | data mart | c. | replicated database | b. | relational database | d. | procedural
database |
|
|
|
53.
|
An object-oriented database uses a(n) ____ to provide a user interface and
connections to other programs.
a. | object-oriented database management system | b. | Java | c. | Visual Basic | d. | object-relational
database management system |
|
|
|
54.
|
Retailers use ____ to upgrade occasional customers into frequent purchasers by
predicting what products they will buy if offered an appropriate incentive.
a. | databases | c. | bots | b. | predictive analysis | d. | systems
analysis |
|