DATABASE MANAGEMENT: FINAL EXAM
A database is an organized collection of ________ related data - Answers - logically
Older systems that often contain data of poor quality are called ________ systems. -
Answers - legacy
Program-data dependence is caused by: - Answers - file descriptors being stored in
each application.
Because applications are often developed independently in file processing systems: -
Answers - unplanned duplicate data files are the rule rather than the exception.
Relational databases establish the relationships between entities by means of common
fields included in a file called a(n): - Answers - relation
A(n) ________ is often developed by identifying a form or report that a user needs on a
regular basis. - Answers - user view
A graphical system used to capture the nature and relationships among data is called
a(n): - Answers - data model
Data that describe the properties of other data are: - Answers - metadata
All of the following are properties of metadata EXCEPT - Answers - processing logic
A person, place, object, event, or concept about which the organization wishes to
maintain - Answers - entity
________ are established between entities in a well-structured database so that the
desired information can be retrieved. - Answers - relationships
All of the following are primary purposes of a database management system (DBMS)
EXCEPT: - Answers - providing an integrated development environment.
With the database approach, data descriptions are stored in a central location known as
a: - Answers - repository
Which organizational function should set database standards? - Answers - none
Which of the following is NOT an advantage of database systems - Answers -
redundant data
The most common source of database failures in organizations is - Answers - failure to
implement a strong database administration function.
, A rule that CANNOT be violated by database users is called a: - Answers - constraint
The three-schema approach includes which of the following schemas? - Answers -
internal
One of the most popular RAD methods is: - Answers - prototyping
The SDLC phase in which the detailed conceptual data model is created is the
________ phase. - Answers - analysis
The traditional methodology used to develop, maintain and replace information systems
is called the - Answers - Systems Development Life Cycle (SDLC)
Database development begins with ________, which establishes the range and general
contents of organizational databases - Answers - Enterprise Data Modeling
A centralized knowledge base of all data definitions, data relationships, screen and
report formats, and other system components is called a(n): - Answers - repository
A knowledge base of information or facts about an enterprise is called a(n): - Answers -
repository
Which of the following is NOT a cost and/or risk of the database approach - Answers -
Improved responsiveness
A workgroup database is stored on a central device called a: - Answers - server
Which of the following is NOT an objective that drove the development and evolution of
database technology? - Answers - The desire to require programmers to write all file
handling functionality
E. F. Codd developed the relational model in the: - Answers - 1970's
In a file processing environment, descriptions for data and the logic for accessing the
data are built into: - Answers - application programs
The logical representation of an organization's data is called a(n): - Answers - entity-
relationship model
A good data definition will describe all of the characteristics of a data object EXCEPT: -
Answers - who can delete the data
A fact is an association between two or more: - Answers - terms
A database is an organized collection of ________ related data - Answers - logically
Older systems that often contain data of poor quality are called ________ systems. -
Answers - legacy
Program-data dependence is caused by: - Answers - file descriptors being stored in
each application.
Because applications are often developed independently in file processing systems: -
Answers - unplanned duplicate data files are the rule rather than the exception.
Relational databases establish the relationships between entities by means of common
fields included in a file called a(n): - Answers - relation
A(n) ________ is often developed by identifying a form or report that a user needs on a
regular basis. - Answers - user view
A graphical system used to capture the nature and relationships among data is called
a(n): - Answers - data model
Data that describe the properties of other data are: - Answers - metadata
All of the following are properties of metadata EXCEPT - Answers - processing logic
A person, place, object, event, or concept about which the organization wishes to
maintain - Answers - entity
________ are established between entities in a well-structured database so that the
desired information can be retrieved. - Answers - relationships
All of the following are primary purposes of a database management system (DBMS)
EXCEPT: - Answers - providing an integrated development environment.
With the database approach, data descriptions are stored in a central location known as
a: - Answers - repository
Which organizational function should set database standards? - Answers - none
Which of the following is NOT an advantage of database systems - Answers -
redundant data
The most common source of database failures in organizations is - Answers - failure to
implement a strong database administration function.
, A rule that CANNOT be violated by database users is called a: - Answers - constraint
The three-schema approach includes which of the following schemas? - Answers -
internal
One of the most popular RAD methods is: - Answers - prototyping
The SDLC phase in which the detailed conceptual data model is created is the
________ phase. - Answers - analysis
The traditional methodology used to develop, maintain and replace information systems
is called the - Answers - Systems Development Life Cycle (SDLC)
Database development begins with ________, which establishes the range and general
contents of organizational databases - Answers - Enterprise Data Modeling
A centralized knowledge base of all data definitions, data relationships, screen and
report formats, and other system components is called a(n): - Answers - repository
A knowledge base of information or facts about an enterprise is called a(n): - Answers -
repository
Which of the following is NOT a cost and/or risk of the database approach - Answers -
Improved responsiveness
A workgroup database is stored on a central device called a: - Answers - server
Which of the following is NOT an objective that drove the development and evolution of
database technology? - Answers - The desire to require programmers to write all file
handling functionality
E. F. Codd developed the relational model in the: - Answers - 1970's
In a file processing environment, descriptions for data and the logic for accessing the
data are built into: - Answers - application programs
The logical representation of an organization's data is called a(n): - Answers - entity-
relationship model
A good data definition will describe all of the characteristics of a data object EXCEPT: -
Answers - who can delete the data
A fact is an association between two or more: - Answers - terms
