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