Chapter 03: Database Systems, Data Centers, and Business Intelligence
1. A database, a database management system (DBMS), and the application programs that use the data make up a
database environment.
a.
True
b.
False
True
1
Easy
03.01
2. A collection of fields about a specific object is a record.
a.
True
b.
False
True
1
Easy
03.01
3. By separating descriptions of the characteristics of an object, activity, or individual, a record can provide a complete
description of it.
a.
True
b.
False
False
1
Easy
03.01
4. The specific value of an attribute is called a data entity.
a.
True
b.
False
False
1
Easy
03.01
5. Several records can share the same primary key.
a.
True
b.
False
Chapter 03: Database Systems, Data Centers, and Business Intelligence
False
1
Easy
03.01
6. Today, most organizations use the traditional approach to data management, where multiple information systems share
a pool of related data.
a.
True
b.
False
False
1
Easy
03.01
7. To use the database approach to data management, no additional software is required.
a.
True
b.
False
False
1
03.01
8. A database should be designed to store all data relevant to a business and provide quick access and easy modification.
a.
True
b.
False
True
1
Easy
03.02
9. When organizing a database, one of the key considerations include determining who will have access to the collected
data.
a.
True
b.
False
True
1
Easy
10. A data model is a diagram of data attributes and their relationships.
a.
True
b.
False
False
1
Easy
03.02
11. A field represents a circuit that is either on or off.
a.
True
b.
False
False
1
Easy
03.01
12. In the relational model, each column in the table represents an entity, and each row represents an attribute of that
entity.
a.
True
b.
False
False
1
Easy
03.02
13. One of the primary advantages of a relational database is that it reduces data redundancy and allows data to be
organized more logically.
a.
True
b.
False
True
1
Easy
03.02
03.02
14. Oracle is currently the market leader in general purpose databases, with about three-fourths of the multibillion dollar
database market.
a.
True
b.
False
False
1
Easy
03.02
15. One data cleansing solution is to identify and correct the data by cross-checking it against a validated data set.
a.
True
b.
False
True
1
Easy
03.02
16. In the context of relational database model, selecting involves combining two or more tables.
a.
True
b.
False
False
1
Easy
03.02
17. A database installed on a personal computer is typically meant for a single user.
a.
True
b.
False
True
1
Easy
03.03
18. The goal of a Structured Query Language (SQL) database is to provide faster performance and greater scalability.
a.
True
b.
False
Chapter 03: Database Systems, Data Centers, and Business Intelligence
False
1
Easy
03.03
19. A NoSQL database is highly scalable, meaning that a large database may be distributed across hundreds, thousands, or
even tens of thousands of servers running the same NoSQL database management system.
a.
True
b.
False
True
1
Easy
03.03
20. One of the final steps in installing and using a large database involves “telling” the database management system
(DBMS) the logical and physical structure of the data and the relationships among the data for each user.
a.
True
b.
False
False
1
Easy
03.03
21. The database management system (DBMS) serves as an interface between an application program and a database.
a.
True
b.
False
True
1
Easy
03.03
22. The role of a data administrator is to plan, design, create, operate, secure, monitor, and maintain databases.
a.
True
b.
False
False
1
Easy
23. In a database management system (DBMS), a front-end application interacts with other programs or applications; it
only indirectly interacts with people or users.
a.
True
b.
False
False
1
Easy
03.03
24. In-memory databases (IMDBs )perform best on multiple multicore central processing units (CPUs) that can process
parallel requests to the data.
a.
True
b.
False
True
1
Easy
03.04
25. A data warehouse stores historical data that has been extracted from operational systems and external sources.
a.
True
b.
False
True
1
Easy
03.04
26. Data warehouses keep the same data for long periods of time so the probability that the sources contain “dirty data” is
low.
a.
True
b.
False
False
1
Easy
03.04
03.03
27. Online analytical processing (OLAP) and data mining are essentially the same thing.
a.
True
b.
False
False
1
Easy
03.04
28. A business intelligence dashboard cannot be tailored to display metrics targeted for a single point or department.
a.
True
b.
False
False
1
Easy
03.04
29. Business intelligence is gained through industrial espionage and the gathering of this information often includes illegal
or unethical means.
a.
True
b.
False
False
1
Easy
03.04
30. One of the most effective competitive intelligence measures is to define “trade secret” information relevant to a
company and control its dissemination.
a.
True
b.
False
False
1
Easy
03.04
31. Which of the following statements is true of a database?
Chapter 03: Database Systems, Data Centers, and Business Intelligence
It is accessed primarily for use by an
organization’s database administrator and data
administrator.
b.
It provides an essential foundation for an organization’s
knowledge management and artificial intelligence
systems.
It is a collection of unstructured data.
d.
It helps companies analyze information to open new
market opportunities.
d
1
Moderate
03.01
United States – BUSPROG: Technology
Bloom’s: Comprehension
32. A(n) _____ is a basic building block of most information, consisting of upper-case letters, lowercase letters, numeric
digits, or special symbols.
entity
b.
byte
bit
d.
character
d
1
Easy
03.01
United States – BUSPROG: Technology
Bloom’s: Knowledge
33. A(n) _____ is typically a name, number, or combination of characters that describes an aspect of a business object or
activity.
field
b.
attribute
record
d.
file
a
1
Easy
03.01
United States – BUSPROG: Technology
Bloom’s: Knowledge
34. A(n) _____ is a person, place, or thing (object) for which data is collected, stored, and maintained.
entity
b.
record
field
d.
character
a
1
Easy
03.01
United States – BUSPROG: Technology
Bloom’s: Knowledge
35. A(n) _____ is s field or set of fields in a record that uniquely defines the record.
Chapter 03: Database Systems, Data Centers, and Business Intelligence
attribute
b.
entity
primary key
d.
data item
c
1
Easy
03.01
United States – BUSPROG: Technology
Bloom’s: Knowledge
36. _____ is an approach to data management whereby each distinct operational system uses data files dedicated to that
system.
Company approach to data management
b.
Database approach to data management
Enterprise approach to data management
d.
Traditional approach to data management
d
1
Easy
03.01
United States – BUSPROG: Technology
Bloom’s: Knowledge
37. _____ is an approach that starts by investigating the general data and information needs of the organization at the
strategic level and then examines more specific data and information needs for the functional areas and departments
within the organization.
Enterprise data modeling
b.
Social graph analysis
Data selecting
d.
Data cleansing
a
1
Easy
03.02
United States – BUSPROG: Technology
Bloom’s: Knowledge
38. Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain
criteria.
selecting
b.
joining
projecting
d.
linking
a
1
Easy
03.02
United States – BUSPROG: Technology
Bloom’s: Knowledge
39. In a relational database, _____ is the ability to combine two or more tables through common data attributes to form a
new table with only the unique data attributes.
Chapter 03: Database Systems, Data Centers, and Business Intelligence
linking
b.
joining
combining
d.
selecting
a
1
Easy
03.02
United States – BUSPROG: Technology
Bloom’s: Knowledge
40. A(n) _____ is a simple database program whose records have no relationship to one another.
flat file
b.
schema
relational system
d.
user view
a
1
Easy
03.02
United States – BUSPROG: Technology
Bloom’s: Knowledge
41. _____ databases rely upon concurrency control by locking database records to ensure that other transactions do not
modify the database until the first transaction succeeds or fails, and as a result, can suffer from slow performance.
Query by Example (QBE)
b.
Access
Structured Query Language (SQL)
d.
Data manipulation language (DML)
1
Easy
03.03
United States – BUSPROG: Technology
Bloom’s: Knowledge
42. A _____ is a description that involves “telling” the database management system (DBMS) the logical and physical
structure of the data and the relationships among the data for each user.
diagram
b.
model
schema
d.
register
c
1
Easy
03.03
United States – BUSPROG: Technology
Bloom’s: Knowledge
43. A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific
database.
data dictionary
b.
schema
data definition language
d.
database manipulation language
Chapter 03: Database Systems, Data Centers, and Business Intelligence
c
1
Easy
03.03
United States – BUSPROG: Technology
Bloom’s: Knowledge
44. One of the most effective counterintelligence measures is to define _____ information relevant to a company and
control its dissemination.
grapevine
b.
trade secret
public
d.
data loss
b
1
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
45. Some databases use ______, which is a visual approach to developing queries and requests.
Query by Example (QBE)
b.
user views
structured query language (SQL)
d.
data manipulation language (DML)
a
1
03.03
United States – BUSPROG: Technology
Bloom’s: Knowledge
46. With _____, the database is stored on a service provider’s server and accessed by the client over a network, typically
the Internet.
Internet access
b.
Database as a Service
Software as a Service
d.
Oracle
b
1
Easy
03.03
United States – BUSPROG: Technology
Bloom’s: Knowledge
47. _____ is the term used to describe enormous and complex data collections that traditional data management software,
hardware, and analysis processes are incapable of dealing with them.
Data warehouse
b.
Datamart
Big data
d.
Knowledge base
c
1
48. Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.
roll up
b.
drill down
slice and dice
d.
extract data
b
1
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
49. A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within
large companies to support decision making.
data dictionary
b.
data model
data mart
d.
data mine
c
1
Easy
03.04
Bloom’s: Knowledge
50. _____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data
warehouse.
Data mining
b.
Counterintelligence
Competitive intelligence
d.
Enterprise data modeling
a
1
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
51. ______ is a form of database processing that supports top-down, query-driven data analysis.
Social graph analysis
b.
Online analytical processing
Data warehousing
d.
Data mining
b
1
Easy
03.04
United States – BUSPROG: Technology
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
52. _____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the
outcomes of events.
Business intelligence
b.
Social graph analysis
Online analytical processing
d.
Predictive analysis
d
1
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
53. _____ is a data visualization technique in which data is represented as networks where the vertices are the individual
data points and the edges are the connections among them.
Entity graph analysis
b.
Performance analysis
Social graph analysis
d.
Predictive analysis
c
1
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
54. A business intelligence dashboard is a _____ tool that displays the current status of the key performance
indicators (KPIs) for an organization.
online analytical processing
b.
data mining
data visualization
d.
predictive analysis
c
1
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
55. The term _____ describes the steps an organization takes to protect information sought by “hostile” intelligence
gathers.
data loss prevention
b.
trade secret
counterintelligence
d.
competitive intelligence
c
1
Easy
03.04
United States – BUSPROG: Technology
Bloom’s: Knowledge
Bloom’s: Knowledge
56. A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data
issues.
57. A(n) ______ consists of a group of programs that manipulate the database and provide an interface between the
database and its users and other application programs.
58. _____ fields include the total, average, maximum, and minimum value.
59. A collection of related records is called a(n) _____.
60. Together, bits, characters, fields, records, files, and databases form the _____.
61. A(n) _____ is a characteristic of an entity.
62. The specific value of an attribute, called a(n) _____, can be found in the fields of a record describing an entity.
63. _____ is an approach to data management where multiple information systems share a pool of related data.
64. ______ use basic graphical symbols to show an organization of and relationships between data.
65. The _____ is a simple but highly useful way to organize data into collections of two-dimensional tables called
relations.
66. In the relational database model, each row in a table represents a(n) _____.
67. In a relational database model, the range of allowable values for a data attribute is called its _____.
68. In the context of relational database model, _____ involves eliminating columns in a table.
69. _____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records
that reside in a database.
70. Small, midsize, and large businesses need _____ database management systems (DBMSs) to share information
throughout the organization over a network.
71. A(n) _____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions
associated with the relational database model in order to provide faster performance and greater scalability.
72. A(n) _____ is a detailed description of all data used in a database.
1
73. _____ is a method of dealing with a situation in which two or more users or applications need to access the same
record at the same time.
1
74. The _____ is a specific language, provided with a database management system (DBMS), which allows users
to access and modify the data, to make queries, and to generate reports.
1
75. _____ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest
mainframe computers.
1
76. A(n) ______ is an individual who is expected to have a clear understanding of the fundamental business of an
1
Chapter 03: Database Systems, Data Centers, and Business Intelligence
organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies
and new design approaches.
77. The key element in predictive analytics is the _____, one or more variables that can be measured for an individual to
predict future behavior.
78. One of the best ways to gain insights into data is through _____ techniques that can help quickly draw conclusions and
see relationships among the data.
79. _____ are quantifiable measurements that assess progress toward organizational goals and reflect the critical success
factors of an organization.
80. _____ is one aspect of business intelligence and encompasses information about competitors and the ways that
knowledge affects strategy, tactics, and operations.
81. Briefly describe the hierarchy of data.
82. Differentiate between the traditional and database approach to data management.
83. Briefly describe the relational database model.
84. Describe business intelligence (BI).
85. Explain entity-relationship (ER) diagrams.