Test Bank for Modern Database Management, 13th
Edition – Hoffer, Venkataraman, Topi
Global enterprises data storage (2010) - CORRECT ANSWER ✅✅✅At least
100 petabytes of data.
Database management - CORRECT ANSWER ✅✅✅Involves collecting data,
organizing data, and managing data.
Database - CORRECT ANSWER ✅✅✅An organized collection of logically
related data.
Legacy systems - CORRECT ANSWER ✅✅✅Often contain data of poor
quality and are generally hosted on mainframes.
Program-data dependence - CORRECT ANSWER ✅✅✅Caused by file
descriptions being stored in each database application.
File processing systems - CORRECT ANSWER ✅✅✅Unplanned duplicate
data files are the rule rather than the exception.
Relational databases - CORRECT ANSWER ✅✅✅Establish relationships
between entities by means of common fields included in a file called a relation.
User view - CORRECT ANSWER ✅✅✅A logical description of some portion
of the database.
,Data model - CORRECT ANSWER ✅✅✅A graphical system used to capture
the nature and relationships among data.
Metadata - CORRECT ANSWER ✅✅✅Data that describe the properties of
other data.
Metadata descriptions - CORRECT ANSWER ✅✅✅Typically describe data
definitions, length, and allowable values.
Entity - CORRECT ANSWER ✅✅✅A person, place, object, event, or concept
about which the organization wishes to maintain data.
Relationships - CORRECT ANSWER ✅✅✅Established between entities in a
well-structured database so that the desired information can be retrieved.
Database Management System (DBMS) - CORRECT ANSWER ✅✅✅Primary
purposes include creating data, updating data, and storing data.
Central location for data descriptions - CORRECT ANSWER ✅✅✅Known as
a repository.
Data warehouses vs. big data - CORRECT ANSWER ✅✅✅The data is
unstructured in big data systems.
Database standards - CORRECT ANSWER ✅✅✅Should be set by Database
Administration.
Structured Query Language (SQL) - CORRECT ANSWER ✅✅✅A tool even
non-programmers can use to access information from a database.
, Disadvantage of database systems - CORRECT ANSWER ✅✅✅Redundant
data.
Database failures - CORRECT ANSWER ✅✅✅The most common source of
database failures in organizations is failure to implement a strong database
administration function.
Constraint - CORRECT ANSWER ✅✅✅A rule that CANNOT be violated by
database users.
File processing environment - CORRECT ANSWER ✅✅✅In a file processing
environment, descriptions for data and the logic for accessing the data are
built into application programs.
Relational model - CORRECT ANSWER ✅✅✅E. F. Codd developed the
relational model in the 1970s.
Database technology objectives - CORRECT ANSWER ✅✅✅An objective
that drove the development and evolution of database technology is the need
to provide greater independence between programs and data.
Proof of concept - CORRECT ANSWER ✅✅✅The period that can be
considered a 'proof of concept' time was the 1960s.
Multi-tiered client/server database - CORRECT ANSWER ✅✅✅A
departmental multi-tiered client/server database is stored on a central device
called a server.
Edition – Hoffer, Venkataraman, Topi
Global enterprises data storage (2010) - CORRECT ANSWER ✅✅✅At least
100 petabytes of data.
Database management - CORRECT ANSWER ✅✅✅Involves collecting data,
organizing data, and managing data.
Database - CORRECT ANSWER ✅✅✅An organized collection of logically
related data.
Legacy systems - CORRECT ANSWER ✅✅✅Often contain data of poor
quality and are generally hosted on mainframes.
Program-data dependence - CORRECT ANSWER ✅✅✅Caused by file
descriptions being stored in each database application.
File processing systems - CORRECT ANSWER ✅✅✅Unplanned duplicate
data files are the rule rather than the exception.
Relational databases - CORRECT ANSWER ✅✅✅Establish relationships
between entities by means of common fields included in a file called a relation.
User view - CORRECT ANSWER ✅✅✅A logical description of some portion
of the database.
,Data model - CORRECT ANSWER ✅✅✅A graphical system used to capture
the nature and relationships among data.
Metadata - CORRECT ANSWER ✅✅✅Data that describe the properties of
other data.
Metadata descriptions - CORRECT ANSWER ✅✅✅Typically describe data
definitions, length, and allowable values.
Entity - CORRECT ANSWER ✅✅✅A person, place, object, event, or concept
about which the organization wishes to maintain data.
Relationships - CORRECT ANSWER ✅✅✅Established between entities in a
well-structured database so that the desired information can be retrieved.
Database Management System (DBMS) - CORRECT ANSWER ✅✅✅Primary
purposes include creating data, updating data, and storing data.
Central location for data descriptions - CORRECT ANSWER ✅✅✅Known as
a repository.
Data warehouses vs. big data - CORRECT ANSWER ✅✅✅The data is
unstructured in big data systems.
Database standards - CORRECT ANSWER ✅✅✅Should be set by Database
Administration.
Structured Query Language (SQL) - CORRECT ANSWER ✅✅✅A tool even
non-programmers can use to access information from a database.
, Disadvantage of database systems - CORRECT ANSWER ✅✅✅Redundant
data.
Database failures - CORRECT ANSWER ✅✅✅The most common source of
database failures in organizations is failure to implement a strong database
administration function.
Constraint - CORRECT ANSWER ✅✅✅A rule that CANNOT be violated by
database users.
File processing environment - CORRECT ANSWER ✅✅✅In a file processing
environment, descriptions for data and the logic for accessing the data are
built into application programs.
Relational model - CORRECT ANSWER ✅✅✅E. F. Codd developed the
relational model in the 1970s.
Database technology objectives - CORRECT ANSWER ✅✅✅An objective
that drove the development and evolution of database technology is the need
to provide greater independence between programs and data.
Proof of concept - CORRECT ANSWER ✅✅✅The period that can be
considered a 'proof of concept' time was the 1960s.
Multi-tiered client/server database - CORRECT ANSWER ✅✅✅A
departmental multi-tiered client/server database is stored on a central device
called a server.
