Test Bank for Modern Database Management 13 th
Edition by Hoffer, Ramesh, and Topi
, Chapterg1g ThegDatabasegEnvironmentgandgDevelopmentgProcess
1.
According to the McKinsey Global Institute Report, in 2010 alone, worldwide companies saved more than:
A) 1 terabyte of data
B) 3 gigabytes of data
C) at least 100 petabytes of data
D) over 7 billion exabytes of data
Correct Answer: D
Rationale: The report highlighted the massive scale of data savings, with global businesses conserving more than 7 billion
exabytes, illustrating the explosive growth of big data. Options A, B, and C represent far smaller data volumes and do not
reflect the true magnitude of storage documented in 2010.
2.
Managing a database involves all of the following actions EXCEPT:
A) Collecting data
B) Organizing information
C) Designing web content
D) Administering data
Correct Answer: C
Rationale: Database management includes data collection, organization, and administration. Designing web content is
outside the scope of database management and instead falls under web development.
3.
A database is a(n) __________ grouping of related information.
A) Logical
B) Physical
C) Loose
D) Poor
Correct Answer: A
Rationale: Databases organize data in a logical manner, making it meaningful and structured for retrieval. Physical
grouping refers to hardware storage, while “loose” and “poor” do not accurately describe database structure.
4.
Older computer systems generally contain __________ quality data and are often hosted on __________.
A) Low; personal computers
B) High; mainframes
C) Low; mainframes
D) High; departmental computers
Correct Answer: C
Rationale: Legacy systems typically store low-quality data due to outdated technology and are usually run on mainframes.
Options A, B, and D mix correct terms incorrectly—mainframes are correct, but the data quality is low, not high.
5.
Program-data dependency arises from:
A) File information being defined within every data application
B) Data details being stored on a server
C) Embedding data descriptions inside programming logic
D) Placing data and programs together
Correct Answer: A
Rationale: In file-based systems, each application defines its own data, creating program-data dependency. This leads to
,redundancy and inflexibility. Option B refers to storage, C overlaps with logic coupling, and D is too general—A most
accurately explains the dependency issue.
6.
In file-based processing systems, because applications are developed independently:
A) Data is never duplicated
B) Unintentional data duplication is common
C) Data is always easy to access across applications
D) File input/output is minimal
Correct Answer: B
Rationale: Independent development often causes the same data to be stored in multiple locations, leading to
duplication. Option A is incorrect because duplication is actually frequent. Option C is false since data is difficult
to share across applications. Option D is wrong because file I/O is usually heavy, not minimal.
7.
A relational database links entities using common fields stored in a file known as a(n):
A) Entity
B) Relationship
C) Relation
D) Association
Correct Answer: C
Rationale: In relational databases, a relation (table) stores rows (records) and columns (fields), using keys to
connect entities. Options A, B, and D describe concepts but not the file structure itself.
8.
A(n) __________ is often built from a form or report that a user regularly requires.
A) Organizational view
B) Data report
C) User view
D) Snapshot
Correct Answer: C
Rationale: A user view shows how the data appears to a particular user, usually based on forms or reports.
Options A and B are broader and not specific to customization, while D refers to a moment-in-time capture.
9.
A visual tool used to map the structure and relationships among data is called a(n):
A) XML data model
B) Hypertext graphic
C) Relational database
D) Data model
Correct Answer: D
Rationale: A data model graphically represents entities, attributes, and their relationships. XML and relational
databases describe formats or systems, not tools. A hypertext graphic refers to web structures.
10.
Data that provides descriptive details about other data is called:
A) Relationships
, B) Logical data
C) Physical data
D) Metadata
Correct Answer: D
Rationale: Metadata is “data about data,” such as field names, lengths, and formats. Relationships describe
associations, while logical and physical data describe organization and storage, not descriptions.
11.
Metadata typically includes all of the following EXCEPT:
A) Data element definitions
B) Size or length of data
C) Acceptable values
D) File’s physical storage location
Correct Answer: D
Rationale: Metadata focuses on logical descriptions like definitions, size, and valid values. Physical storage
location is not part of metadata but instead relates to hardware/system details.
12.
A(n) __________ is a person, place, object, event, or concept about which an organization wants to collect data.
A) Relationship
B) Object
C) Attribute
D) Entity
Correct Answer: D
Rationale: An entity represents something of importance to track data about (e.g., employees, products).
Attributes describe entity details, relationships show connections, and “object” is too broad.
13.
In a well-structured database, __________ are defined between entities to retrieve necessary data.
A) Entities
B) Relationships
C) Lines
D) Ties
Correct Answer: B
Rationale: Relationships link entities (e.g., customers to orders). Options C and D are informal terms. Option A
alone doesn’t represent connections.
14.
All of the following are core functions of a DBMS EXCEPT:
A) Creating data
B) Updating records
C) Storing data
D) Providing an integrated development platform
Correct Answer: D
Rationale: DBMS functions include data creation, storage, and updating. Providing an integrated development
platform is a function of application development tools, not the DBMS itself.
Edition by Hoffer, Ramesh, and Topi
, Chapterg1g ThegDatabasegEnvironmentgandgDevelopmentgProcess
1.
According to the McKinsey Global Institute Report, in 2010 alone, worldwide companies saved more than:
A) 1 terabyte of data
B) 3 gigabytes of data
C) at least 100 petabytes of data
D) over 7 billion exabytes of data
Correct Answer: D
Rationale: The report highlighted the massive scale of data savings, with global businesses conserving more than 7 billion
exabytes, illustrating the explosive growth of big data. Options A, B, and C represent far smaller data volumes and do not
reflect the true magnitude of storage documented in 2010.
2.
Managing a database involves all of the following actions EXCEPT:
A) Collecting data
B) Organizing information
C) Designing web content
D) Administering data
Correct Answer: C
Rationale: Database management includes data collection, organization, and administration. Designing web content is
outside the scope of database management and instead falls under web development.
3.
A database is a(n) __________ grouping of related information.
A) Logical
B) Physical
C) Loose
D) Poor
Correct Answer: A
Rationale: Databases organize data in a logical manner, making it meaningful and structured for retrieval. Physical
grouping refers to hardware storage, while “loose” and “poor” do not accurately describe database structure.
4.
Older computer systems generally contain __________ quality data and are often hosted on __________.
A) Low; personal computers
B) High; mainframes
C) Low; mainframes
D) High; departmental computers
Correct Answer: C
Rationale: Legacy systems typically store low-quality data due to outdated technology and are usually run on mainframes.
Options A, B, and D mix correct terms incorrectly—mainframes are correct, but the data quality is low, not high.
5.
Program-data dependency arises from:
A) File information being defined within every data application
B) Data details being stored on a server
C) Embedding data descriptions inside programming logic
D) Placing data and programs together
Correct Answer: A
Rationale: In file-based systems, each application defines its own data, creating program-data dependency. This leads to
,redundancy and inflexibility. Option B refers to storage, C overlaps with logic coupling, and D is too general—A most
accurately explains the dependency issue.
6.
In file-based processing systems, because applications are developed independently:
A) Data is never duplicated
B) Unintentional data duplication is common
C) Data is always easy to access across applications
D) File input/output is minimal
Correct Answer: B
Rationale: Independent development often causes the same data to be stored in multiple locations, leading to
duplication. Option A is incorrect because duplication is actually frequent. Option C is false since data is difficult
to share across applications. Option D is wrong because file I/O is usually heavy, not minimal.
7.
A relational database links entities using common fields stored in a file known as a(n):
A) Entity
B) Relationship
C) Relation
D) Association
Correct Answer: C
Rationale: In relational databases, a relation (table) stores rows (records) and columns (fields), using keys to
connect entities. Options A, B, and D describe concepts but not the file structure itself.
8.
A(n) __________ is often built from a form or report that a user regularly requires.
A) Organizational view
B) Data report
C) User view
D) Snapshot
Correct Answer: C
Rationale: A user view shows how the data appears to a particular user, usually based on forms or reports.
Options A and B are broader and not specific to customization, while D refers to a moment-in-time capture.
9.
A visual tool used to map the structure and relationships among data is called a(n):
A) XML data model
B) Hypertext graphic
C) Relational database
D) Data model
Correct Answer: D
Rationale: A data model graphically represents entities, attributes, and their relationships. XML and relational
databases describe formats or systems, not tools. A hypertext graphic refers to web structures.
10.
Data that provides descriptive details about other data is called:
A) Relationships
, B) Logical data
C) Physical data
D) Metadata
Correct Answer: D
Rationale: Metadata is “data about data,” such as field names, lengths, and formats. Relationships describe
associations, while logical and physical data describe organization and storage, not descriptions.
11.
Metadata typically includes all of the following EXCEPT:
A) Data element definitions
B) Size or length of data
C) Acceptable values
D) File’s physical storage location
Correct Answer: D
Rationale: Metadata focuses on logical descriptions like definitions, size, and valid values. Physical storage
location is not part of metadata but instead relates to hardware/system details.
12.
A(n) __________ is a person, place, object, event, or concept about which an organization wants to collect data.
A) Relationship
B) Object
C) Attribute
D) Entity
Correct Answer: D
Rationale: An entity represents something of importance to track data about (e.g., employees, products).
Attributes describe entity details, relationships show connections, and “object” is too broad.
13.
In a well-structured database, __________ are defined between entities to retrieve necessary data.
A) Entities
B) Relationships
C) Lines
D) Ties
Correct Answer: B
Rationale: Relationships link entities (e.g., customers to orders). Options C and D are informal terms. Option A
alone doesn’t represent connections.
14.
All of the following are core functions of a DBMS EXCEPT:
A) Creating data
B) Updating records
C) Storing data
D) Providing an integrated development platform
Correct Answer: D
Rationale: DBMS functions include data creation, storage, and updating. Providing an integrated development
platform is a function of application development tools, not the DBMS itself.
