Test Bank for Modern Database Management, 14th Edition by Jeff Hoffer
Chapter 01 - 14e Answers Included
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored 1)
________.
A) more than 3 gigabytes of data B) more than 7 billion exabytes of data
C) at least 100 petabytes of data D) more than 1 terabyte of data
2) A database is an organized collection of ________ related data. 2)
A) loosely B) logically C) physically D) badly
3) Legacy systems often contain data of ________ quality. 3)
A) untested B) moderate C) excellent D) poor
4) Program-data dependence is caused by ________. 4)
A) file descriptions being stored in each database application program
B) data descriptions being written into programming code
C) data descriptions being stored on a server
D) data cohabiting with programs
5) Because applications are often developed independently in file processing systems ________. 5)
A) there is a large volume of file I/O
B) unplanned duplicate data files are the rule rather than the exception
C) data can always be shared with others
D) the data is always non-redundant
6) Relational databases establish the relationships between entities by means of common fields 6)
included in a file called a(n) ________.
A) relation B) entity C) relationship D) association
7) A(n) ________ is often developed by identifying a form or report that a user needs on a regular 7)
basis.
A) user snapshot B) user view
C) enterprise view D) reporting document
8) Data that describe the properties of other data are ________. 8)
A) physical B) relationships C) metadata D) logical
9) Metadata typically describes all of the following EXCEPT ________. 9)
A) length B) allowable values
C) data definitions D) location on disk
10) A person, place, object, event, or concept about which the organization wishes to maintain data 10)
is called a(n) ________.
A) attribute B) object C) relationship D) entity
1
,11) ________ are established between entities in a well-structured database so that the desired 11)
information can be retrieved.
A) Relationships B) Ties C) Entities D) Lines
12) All of the following are primary purposes of a database management system (DBMS) EXCEPT 12)
________.
A) creating data
B) storing data
C) updating data
D) providing an integrated development environment
13) With the database approach, data descriptions are stored in a central location known as a 13)
________.
A) server B) mainframe C) repository D) PC
14) A user view is ________. 14)
A) a report that the user can generate from the data
B) a procedure stored on the server
C) a logical description of some portion of the database
D) a table or set of tables
15) ________ is a tool even non-programmers can use to access information from a database. 15)
A) SQL (Structured query language) B) ODBC
C) Data manipulation query language D) ASP
16) Which of the following is NOT an advantage of database systems? 16)
A) Program-data independence B) Redundant data
C) Improved data quality D) Reduced program maintenance
17) The most common source of database failures in organizations is ________. 17)
A) lack of planning
B) inadequate hardware
C) inadequate budget
D) failure to implement a strong database administration function
18) A rule that CANNOT be violated by database users is called a ________. 18)
A) view B) password C) constraint D) program
19) In a file processing environment, descriptions for data and the logic for accessing the data are 19)
built into ________.
A) database descriptors B) fields
C) records D) application programs
20) E. F. Codd developed the relational model in the ________. 20)
A) 1960s B) 1970s C) 1980s D) 1990s
2
,21) Which of the following is NOT an objective that drove the development and evolution of 21)
database technology?
A) The need to provide greater independence between programs and data.
B) The need to provide ever more powerful platforms for decision support applications.
C) The desire to manage increasing complex data types and structures.
D) The desire to require programmers to write all file handling functionality.
22) Organizations that utilize the file processing approach spend as much as ________ of their IS 22)
development budget on maintenance.
A) 40 percent B) 60 percent C) 25 percent D) 80 percent
23) Which of the following is NOT a cost and/or risk of the database approach? 23)
A) Specialized personnel B) Conversion costs
C) Organizational conflict D) Improved responsiveness
24) A knowledge base of information or facts about an enterprise is called a(n) ________. 24)
A) systems information unit B) database process
C) enterprise information system D) repository
25) Which of the following is a software system used to create, maintain, and provide controlled 25)
access to databases?
A) User view B) Network operating system
C) Database management system (DBMS) D) Attribute
26) Languages, menus, and other facilities by which users interact with various system components 26)
are collectively called a(n) ________.
A) icon B) user interface
C) client D) development environment
27) Database development begins with ________, which establishes the range and general contents 27)
of organizational databases.
A) departmental data modeling B) cross-functional analysis
C) database design D) enterprise data modeling
28) The traditional methodology used to develop, maintain, and replace information systems is 28)
called the ________.
A) Systems Deployment Life Cycle B) Unified Model
C) Systems Development Life Cycle D) Enterprise Resource Model
29) The SDLC phase in which every data attribute is defined, every category of data is listed, and 29)
every business relationship between data entities is defined is called the ________ phase.
A) analysis B) planning
C) design D) implementation
30) The SDLC phase in which database processing programs are created is the ________ phase. 30)
A) analysis B) implementation
C) planning D) design
3
, 31) Specifying how data from a logical schema are stored in secondary memory is part of the 31)
________.
A) implementation B) maintenance
C) analysis D) design
32) An iterative methodology that rapidly repeats the analysis, design, and implementation phases 32)
of the SDLC is called ________.
A) CAD B) RAD C) CASE D) MST
33) ________ specify computer systems requirements. 33)
A) Systems analysts B) Programmers
C) Database analysts D) Users
34) The three-schema approach includes which of the following schemas? 34)
A) Logical B) Dissecting
C) Cross-functional D) Internal
35) Determining the structure of data and the relationships between data elements either right 35)
before or at the time of use of the data is called ________.
A) schema on write B) on demand paging
C) tables on write D) caching
TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
36) Information is processed data. 36)
37) Metadata are data that describe the properties of other data. 37)
38) File processing systems have been replaced by database systems in most critical business 38)
applications today.
39) Unplanned duplicate data files are the rule rather than the exception in file processing systems. 39)
40) Many of the disadvantages of file processing systems can also be limitations of databases. 40)
41) With the traditional file processing approach, each application shares data files, thus enabling 41)
much data sharing.
42) Development starts from scratch with the traditional file processing approach because new file 42)
formats, descriptions, and file access logic must be designed for each new program.
43) A data model is a graphical system used to capture the nature and relationships among data. 43)
44) A person is an example of an entity. 44)
45) The data that you are interested in capturing about an entity is called an instance. 45)
46) A relational database establishes the relationships between entities by means of a common field. 46)
4
Chapter 01 - 14e Answers Included
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored 1)
________.
A) more than 3 gigabytes of data B) more than 7 billion exabytes of data
C) at least 100 petabytes of data D) more than 1 terabyte of data
2) A database is an organized collection of ________ related data. 2)
A) loosely B) logically C) physically D) badly
3) Legacy systems often contain data of ________ quality. 3)
A) untested B) moderate C) excellent D) poor
4) Program-data dependence is caused by ________. 4)
A) file descriptions being stored in each database application program
B) data descriptions being written into programming code
C) data descriptions being stored on a server
D) data cohabiting with programs
5) Because applications are often developed independently in file processing systems ________. 5)
A) there is a large volume of file I/O
B) unplanned duplicate data files are the rule rather than the exception
C) data can always be shared with others
D) the data is always non-redundant
6) Relational databases establish the relationships between entities by means of common fields 6)
included in a file called a(n) ________.
A) relation B) entity C) relationship D) association
7) A(n) ________ is often developed by identifying a form or report that a user needs on a regular 7)
basis.
A) user snapshot B) user view
C) enterprise view D) reporting document
8) Data that describe the properties of other data are ________. 8)
A) physical B) relationships C) metadata D) logical
9) Metadata typically describes all of the following EXCEPT ________. 9)
A) length B) allowable values
C) data definitions D) location on disk
10) A person, place, object, event, or concept about which the organization wishes to maintain data 10)
is called a(n) ________.
A) attribute B) object C) relationship D) entity
1
,11) ________ are established between entities in a well-structured database so that the desired 11)
information can be retrieved.
A) Relationships B) Ties C) Entities D) Lines
12) All of the following are primary purposes of a database management system (DBMS) EXCEPT 12)
________.
A) creating data
B) storing data
C) updating data
D) providing an integrated development environment
13) With the database approach, data descriptions are stored in a central location known as a 13)
________.
A) server B) mainframe C) repository D) PC
14) A user view is ________. 14)
A) a report that the user can generate from the data
B) a procedure stored on the server
C) a logical description of some portion of the database
D) a table or set of tables
15) ________ is a tool even non-programmers can use to access information from a database. 15)
A) SQL (Structured query language) B) ODBC
C) Data manipulation query language D) ASP
16) Which of the following is NOT an advantage of database systems? 16)
A) Program-data independence B) Redundant data
C) Improved data quality D) Reduced program maintenance
17) The most common source of database failures in organizations is ________. 17)
A) lack of planning
B) inadequate hardware
C) inadequate budget
D) failure to implement a strong database administration function
18) A rule that CANNOT be violated by database users is called a ________. 18)
A) view B) password C) constraint D) program
19) In a file processing environment, descriptions for data and the logic for accessing the data are 19)
built into ________.
A) database descriptors B) fields
C) records D) application programs
20) E. F. Codd developed the relational model in the ________. 20)
A) 1960s B) 1970s C) 1980s D) 1990s
2
,21) Which of the following is NOT an objective that drove the development and evolution of 21)
database technology?
A) The need to provide greater independence between programs and data.
B) The need to provide ever more powerful platforms for decision support applications.
C) The desire to manage increasing complex data types and structures.
D) The desire to require programmers to write all file handling functionality.
22) Organizations that utilize the file processing approach spend as much as ________ of their IS 22)
development budget on maintenance.
A) 40 percent B) 60 percent C) 25 percent D) 80 percent
23) Which of the following is NOT a cost and/or risk of the database approach? 23)
A) Specialized personnel B) Conversion costs
C) Organizational conflict D) Improved responsiveness
24) A knowledge base of information or facts about an enterprise is called a(n) ________. 24)
A) systems information unit B) database process
C) enterprise information system D) repository
25) Which of the following is a software system used to create, maintain, and provide controlled 25)
access to databases?
A) User view B) Network operating system
C) Database management system (DBMS) D) Attribute
26) Languages, menus, and other facilities by which users interact with various system components 26)
are collectively called a(n) ________.
A) icon B) user interface
C) client D) development environment
27) Database development begins with ________, which establishes the range and general contents 27)
of organizational databases.
A) departmental data modeling B) cross-functional analysis
C) database design D) enterprise data modeling
28) The traditional methodology used to develop, maintain, and replace information systems is 28)
called the ________.
A) Systems Deployment Life Cycle B) Unified Model
C) Systems Development Life Cycle D) Enterprise Resource Model
29) The SDLC phase in which every data attribute is defined, every category of data is listed, and 29)
every business relationship between data entities is defined is called the ________ phase.
A) analysis B) planning
C) design D) implementation
30) The SDLC phase in which database processing programs are created is the ________ phase. 30)
A) analysis B) implementation
C) planning D) design
3
, 31) Specifying how data from a logical schema are stored in secondary memory is part of the 31)
________.
A) implementation B) maintenance
C) analysis D) design
32) An iterative methodology that rapidly repeats the analysis, design, and implementation phases 32)
of the SDLC is called ________.
A) CAD B) RAD C) CASE D) MST
33) ________ specify computer systems requirements. 33)
A) Systems analysts B) Programmers
C) Database analysts D) Users
34) The three-schema approach includes which of the following schemas? 34)
A) Logical B) Dissecting
C) Cross-functional D) Internal
35) Determining the structure of data and the relationships between data elements either right 35)
before or at the time of use of the data is called ________.
A) schema on write B) on demand paging
C) tables on write D) caching
TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
36) Information is processed data. 36)
37) Metadata are data that describe the properties of other data. 37)
38) File processing systems have been replaced by database systems in most critical business 38)
applications today.
39) Unplanned duplicate data files are the rule rather than the exception in file processing systems. 39)
40) Many of the disadvantages of file processing systems can also be limitations of databases. 40)
41) With the traditional file processing approach, each application shares data files, thus enabling 41)
much data sharing.
42) Development starts from scratch with the traditional file processing approach because new file 42)
formats, descriptions, and file access logic must be designed for each new program.
43) A data model is a graphical system used to capture the nature and relationships among data. 43)
44) A person is an example of an entity. 44)
45) The data that you are interested in capturing about an entity is called an instance. 45)
46) A relational database establishes the relationships between entities by means of a common field. 46)
4
