Multiple Choice Questions: Data Resource Management

Chapter 05
Data Resource Management

Multiple Choice Questions

© 2013 by McGraw-Hill Education. This is proprietary material solely for authorized instructor use. Not authorized for sale or distribution in
any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.
30. In all information systems, data resources must be organized and structured in some
(p. 178)
logical manner, so that they can be:

A. Easily accessed
B. Processed efficiently
C. Retrieved quickly
D. All of the choices are correct.

31. From a logical point of view, a(n) _______________ is the smallest data element that
(p. 178)
can be observed and manipulated.

A. character
B. bit
C. attribute
D. byte

32. A record represents a collection of _______________ that describe an entity.
(p. 178)

A. characters
B. fields
C. files
D. attributes

33. All the fields used to describe the attributes of an entity are grouped to form a(n)
(p. 178)
_______________.

A. field
B. record
C. fil
e
D. database

34. A group of related records is a data file, or a _______________.
(p. 181)

A. field
B. record
C. table
D. database

35. Variable-length records contain:
(p. 181)

A. both a variable number of fields and variable field lengths.

B. both a variable number of fields and fixed field lengths.
C. both a fixed number of fields and variable field lengths.
D. both a fixed number of fields and fixed field lengths.

36. Fixed-length records contain:
(p. 181)

A. both a variable number of fields and variable field lengths.

B. both a variable number of fields and fixed field lengths.
C. both a fixed number of fields and variable field lengths.
D. both a fixed number of fields and fixed field lengths.

37. When independent of any other files related to it, a single table is referred to as a(n):
(p. 181)

A. Independent file
B. Flat file
C. Hierarchical file
D. Non-variable file

38. A(n) _______________ is an integrated collection of logically related data elements.
(p. 181)

A. master file
B. program base
C. database
D. integrated file

39. Databases contain data elements that describe both entities and the _______________
(p. 182)
among entities.

A. relationships
B. disparities
C. subsets
D. applications

40. Database management packages based on the _______________ model can link data
(p. 184)
elements from various tables to provide information to users.

A. object-oriented
B. relational
C. network
D. hierarchical

41. Early mainframe DBMS packages used the _______________ structure, in which all
(p. 184)
records are dependent and arranged in multilevel structures, consisting of one root
record and any number of subordinate levels.

A. network
B. relational
C. hierarchical
D. object-oriented

42. In a(n) _______________ database structure, all of the relationships among records are
(p. 184)
one-to-many, because each data element is related to only one element above it.

A. hierarchical
B. relational
C. network
D. object-oriented

43. Which database model allows many-to-many relationships among records so that a data
(p. 184)
element can be accessed by following one of several paths?

A. Hierarchical
B. Network
C. Object-oriented
D. Relational

44. The _______________ model is the most widely used database structure today.
(p. 184)

A. network
B. object-oriented
C. relational
D. hierarchical

45. In the relational database model, all data elements within the database are viewed as
(p. 184)
being stored in the form of simple two-dimensional tables, sometimes referred to as
_______________.

A. records
B. rows
C. columns
D. relations

46. The tables in a relational database are flat files which have rows and columns. Each
(p. 184)
row represents a _______________ in the file.

A. field
B. record
C. fil
e
D. relation

47. The tables in a relational database are flat files which have rows and columns. Each
(p. 184)
column represents a _______________ in the file.

A. field
B. record
C. fil
e
D. relation

48. The _______________ operation is used to create a subset of the columns contained in
(p. 185)
the temporary tables created by the select and join operations.

A. lin
k
B. relate
C. project
D. merge

49. Using a relational database, a user can temporarily combine two or more tables so that
(p. 185)
he/she can see relevant data in a form that looks like it is in one big table. This is the
_______________ operation.

A. join
B. lin
k
C. merge
D. select

50. _______________ is the most commonly used database application for the PC.
(p. 185)

A. Oracle 10g
B. Microsoft Access
C. DB2
D. SQL Server

51. _______________ databases have become the most popular structure for analytical
(p. 185)
databases that support online analytical process (OLAP) applications, in which fast
answers to complex queries are expected.

A. Relational
B. Object-oriented
C. Inter-relational
D. Multidimensional

52. The _______________ database structure is considered one of the key technologies of
(p. 185)
a new generation of Web-based applications.

A. hierarchical
B. relational
C. object-oriented
D. multidimensional

53. The object-oriented database model supports _______________. That is, new objects
(p. 185)
can be automatically created by replicating some or all of the characteristics of one or
more parent objects.

A. inheritance
B. morphing
C. duplication
D. cloning

54. Object technology allows designers to do all of the following except:
(p. 185)

A. Develop product designs

B. Replicate product designs and then modify them to create new product designs
C. Save designs as objects in an object-oriented database
D. Substantially reduce the file size of designs

55. Which database structure works effectively with complex data types, such as video
(p. 187)
clips, audio segments, and other subsets of Web pages, and is considered one of the key
technologies of Web-based applications?

A. Hierarchical
B. Network
C. Object-oriented
D. Relational

56. A database with a(n) _______________ data structure can easily handle a many-to-
(p. 187)
many data relationship.

A. hierarchical
B. network
C. relational
D. object-oriented

57. A database with a(n) _______________ data structure can easily handle ad hoc
(p. 187)
requests for information.

A. hierarchical
B. network
C. relational
D. object-oriented

58. According to one database pioneer, the future development of databases and data
(p. 188)
warehouses will depend on _______________.

A. rows
B. columns
C. transaction

59. Large organizations usually place control of enterprise-wide database development in
(p. 188)
the hands of _______________.

A. Database administrators (DBAs)

B. Automated CASE tools
C. End users

60. According to the text, most data warehouses will run _______________ in a column
(p. 188)
format.

A. 20 times faster

B. 50 times faster
C. 50 times slower
D. None of the choices are correct.

61. Database administrators and database design analysts work with end users and systems
(p. 189)
analysts to do all of the following except:

A. Model business processes and the data they require

B. Determine what data definitions should be included in the database
C. Determine what structure or relationships should exist among the data elements
D. Enter live data into the system until it has proven to be reliable

62. _______________ are used to model the relationships among the many entities
(p. 189)
involved in business processes.

A. Entity-relationship diagrams
B. Data-flow diagrams
C. Schema diagrams
D. Subschema diagrams

63. The physical design stage of database development:
(p. 190)

A. Develops a model of business processes

B. Translates conceptual models into the data models
C. Determines the data storage structures and access methods
D. Defines the information needs of end users in a business process

64. The _______________ stage of database development translates the conceptual models
(p. 190)
into the data model of a DBMS.

A. data planning
B. requirements specification
C. conceptual design
D. logical design

65. A _______________ is an overall logical view of the relationships among the data
(p. 190)
elements in a database.

A. schema
B. subschema
C. logical data model
D. conceptual design

66. A _______________ is an overall logical view of the relationships needed to support
(p. 191)
specific end-user application programs that will access the database.

A. schema
B. subschema
C. logical data model
D. conceptual design

67. According to the textbook case, the innovation of the open-source product Hadoop is
(p. 192)
_______________.

A. that it has not been sued by Google

B. that it actually works
C. that it has no proprietary predecessor
D. its algorithms run contrary to contemporary mathematics

68. According to the textbook case, file processing in Hadoop is not halted by hardware
(p. 192)
failures because _______________.

A. Hadoop is a software product

B. Open-source products are not affected by hardware failures
C. Hadoop is an Internet product and does not need hardware
D. Hadoop keeps three (3) copies of all data

69. Operational databases store the detailed data needed to support the business processes
(p. 193)
and operations of a company. They are also called _______________.

A. Subject area databases

B. Transaction databases
C. Production databases

70. The primary challenge of a distributed database is:
(p. 197)

A. Data accuracy
B. Data transmission speed
C. Storage costs
D. Data security

71. Which of the following statements concerning the replication and duplication process
(p. 197)
for updating distributed databases is correct?

A. The two terms are interchangeable because the processes work the same way
B. Duplication is the more complicated process because it has to identify one database
as a master and prevent changes being made to any database other than the master
C. Replication is the more complicated process because it must find changes in each
distributed database and make appropriate changes to make each database identical

72. What type of databases are employees using when they access online data banks,
(p. 197)
whether those data banks are free or paid for through subscriptions?

A. Common databases
B. Distributed databases
C. External databases
D. Local databases

73. A central source of data that have been cleaned, transformed, and cataloged so that they
(p. 199)
can be used for business analysis, market research, and decision support is called a
_______________.

A. data mart
B. data warehouse
C. transaction processing mart
D. data repository

74. A data warehouse contains data that have been processed in all the following ways
(p. 199)
except:

A. Separated
B. Cleaned
C. Transformed
D. Cataloged

75. Which of the following is true of data marts?
(p. 199)

A. They hold data from many different data warehouses.

B. They are a subset of a data warehouse.
C. They focus on many generalized aspects of a company.

76. Which of the following is true of data in a data warehouse?
(p. 199-

200)
A. Data in operational databases is ever changing; data in data warehouses is static

B. Data in operational databases is static; data in data warehouses is ever changing
C. Data in operational databases can be cataloged; data in data warehouses cannot

77. Which of the following is a legitimate use for data mining?
(p. 201)

A. Performing "market-basket analysis" to identify new product bundles

B. Profiling customers
C. Finding the root cause of a quality or manufacturing problem

78. All of the following contribute to problems when using a file management approach
(p. 203)
except:

A. Data redundancy
B. Lack of integration of data
C. Data independence
D. Lack of data integrity

79. Database management involves the use of database management software to control
(p. 204)
how databases are _______________.

A. created
B. interrogated
C. maintained

80. In mainframe and server computer systems, the database management system controls
(p. 204)
the _______________ of the databases of computer-using organizations.

A. maintenance
B. development
C. use

81. All of the following are major functions of a database management system except:
(p. 206)

A. Creating new databases and database applications

B. Identifying insufficient data processing or storage needs
C. Maintaining the quality of the data in an organization's databases
D. Using the databases of an organization to provide the information needed by its end
users

82. Database development involves defining and organizing the _______________ of the
(p. 206)
data needed to build a database.

A. structure
B. content
C. relationships

83. A DBMS query language is designed to:
(p. 206)

A. Support information systems professionals in the development of complex

application software
B. Support end users who wish to obtain ad hoc reports
C. Provide efficient batch mode processing of the database
D. Specify the content, relationships, and structure of a database

84. The database maintenance process is accomplished via:
(p. 206)

A. Hierarchical database systems that provide flexibility and network databases

B. Transaction processing systems and other end user applications, with the support of
the DBMS
C. Graphical query languages correctly phrasing SQL
D. File processing systems with the support of 4GLs

85. The basic form of a SQL query is:
(p. 207)

A. SELECT … AND … OR

B. SELECT … WHERE … FROM …
C. SELECT … FROM … WHERE …
D. AND … OR … NOT …

86. Boolean logic deals with three logical operators:
(p. 207)

A. AND, OR, and BUT

B. AND, NOT, and BUT
C. OR, BUT, and NOT
D. AND, OR, and NOT

87. Many end users have trouble correctly phrasing database language search queries, so
(p. 208)
most end-user DBMS packages now offer _______________ methods.

A. speech recognition
B. command line
C. GUI

Fill in the Blank Questions

88. All of the fields used to describe the attributes of an entity are grouped to form a
(p. 178)
_______________.

record

89. _______________ contain both a variable number of fields and variable field lengths.
(p. 181)

Variable-length records

90. _______________ contain both a fixed number of fields and fixed field lengths.
(p. 181)

Fixed-length records

91. A group of related records is a data file, or a _______________.
(p. 181)

table

92. A _______________ is an integrated collection of logically related data elements.
(p. 181)

database

93. Databases contain data elements that describe both entities and the _______________
(p. 182)
among entities.

relationships

94. In the relational database model, all data elements within the database are viewed as
(p. 184)
being stored in the form of simple, two-dimensional tables, sometimes referred to as
_______________.

relations

95. The tables in a relational database are flat files, which have rows and columns. Each
(p. 184)
row presents a single _______________ in the file.

record

96. The tables in a relational database are flat files, which have rows and columns. Each
(p. 184)
column represents a _______________.

field

97. The _______________ operation is used to create a subset of the columns contained in
(p. 185)
the temporary tables created by the select and join operations.

project

98. An _______________ consists of data values describing the attributes of an entity, plus
(p. 185)
the operations that can be performed upon the data.

object

99. A weakness in the hierarchical model is that it cannot handle _______________ data
(p. 187)
relationships.

many-to-many

100. A weakness in the network model is that it cannot handle _______________ for
(p. 187)
information.

ad hoc requests

101. A database of data definitions and specifications is called a metadata repository, or a
(p. 188)
_______________.

data dictionary

102. Database administrators and designers work with corporate and end user management
(p. 189)
to develop an _______________ model that defines the basic business process of the
enterprise.

enterprise

103. _______________ relationship diagrams are used to model the relationships among the
(p. 189)
many entities involved in business processes.

Entity

104. A _______________ is an overall logical view of the relationships among the data
(p. 190)
elements in a database.

schema

105. _______________ database design takes a physical view of the data that describes how
(p. 191)
data are to be physically stored and accessed on the storage devices of a computer
system.

Physical

106. Data models represent _______________ views of the data and relationships of the
(p. 190)
database.

logical

107. Entity Relationship Diagrams are _______________ of the various files and their
(p. 189)
relationships within a database system.

graphical models

108. A website stores hyperlinked pages of multimedia (text, graphics, photographs, video,
(p. 197)
and audio) in a _______________ database.

hypermedia

109. The duplication process basically identifies one database as a _______________ and
(p. 197)
then duplicates that database at a prescribed time so that each distributed location has
the same data.

master

110. Data warehouses may be subdivided into _______________, which hold subsets of
(p. 199)
data from the warehouse that focus on specific aspects of a company, such as a
department or a business process.

data marts

111. _______________, data that define the data in the data warehouse, are stored in a
(p. 199)
metadata repository and cataloged by a metadata directory.

Metadata

112. In _______________, the data in a data warehouse are analyzed to reveal hidden
(p. 200)
patterns and trends in historical business activity.

data mining

113. To solve the problems encountered with the file processing approach, the
(p. 203)
_______________ management approach was conceived. It is the foundation of
modern methods of managing organizational data.

database

114. Database _______________ involves using transaction processing systems and other
(p. 208)
tools to add, delete, update, and correct the data in a database.

maintenance

115. SQL is an acronym for _______________. It is an international standard query
(p. 206-
language found in many DBMS packages.
207)

Structured Query Language

116. The basic form of a SQL query is SELECT…FROM… _______________.
(p. 207)

WHERE

117. Boolean logic consists of three logical operators: AND, OR, and _______________.
(p. 207)

NOT


Multiple Choice Questions: Data Resource Management

Uploaded by

Copyright:

Available Formats

Multiple Choice Questions: Data Resource Management

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Multiple Choice Questions: Data Resource Management

Uploaded by

Copyright:

Available Formats

Chapter 05

Data Resource Management

Multiple Choice Questions

A. both a variable number of fields and variable field lengths.

A. both a variable number of fields and variable field lengths.

A. Develop product designs

A. Database administrators (DBAs)

A. 20 times faster

A. Model business processes and the data they require

A. Develops a model of business processes

A. that it has not been sued by Google

A. Hadoop is a software product

A. Subject area databases

A. They hold data from many different data warehouses.

A. Data in operational databases is ever changing; data in data warehouses is static

A. Performing "market-basket analysis" to identify new product bundles

A. Creating new databases and database applications

A. Support information systems professionals in the development of complex

A. Hierarchical database systems that provide flexibility and network databases

A. SELECT … AND … OR

A. AND, OR, and BUT

Fill in the Blank Questions

You might also like