Database Design Exam 1 – Study Guide, Key Concepts & Practice Questions
with answers.
One application of data warehouse is decision support
Older systems that often contain data of poor quality legacy
are called systems
A database that is an organized collection logically
relate
d data
Which of the following types of data can be stored in a voice, letters, numbers
database
Data processed in a way that increases a users information
knowledge is
Data that describe the properties of other data are none of the above
A) relationships
B) logical
C)physical
D) none of the above
All of the following are properties of metadata except processing logic
A) data definitions
B) processing logic
C) rules or contraints
D) Data structures
one disadvantage of file processing system is limited data sharing
program data dependence is caused by file descriptors being stored in each application
because applications are often developed independently unpanned duplicate data files are the rule rather than the exception
in file processing systems
Organizations that utilize the file processing approach 80%
spend as much as of their IS development budget
on maintenance
A graphical system used to capture the nature and data model
relationships among data is
A person place an object an event or concept about entity
which the organization wishes to maintain data is called
1/12
, are established between entities in a well relationships
structured database so that the desired information can
be retrieved
Relational databases establish the relationships between relation
entities by means of common fields included in a file called
All of the follwoing are primary purposes of database providing an integrated development environment
management system except
An is developed by identifying a form or report user view
that a user needs on a regular basis
With the database approach, data description are stored repository
in a central location known as
A user is a logical description of some portion of the database
which organizational function should set database none of the above
standards
A) management
B) Application development
C) technical services
D) none of the above
is a tool even non programers can use to access Structured query language
information from a database
Which of the following is not an advantage of a database redundant data
system
the most common source of database failures in failure to implement a strong database administration function
organization is
a rule that cannot be violated by database users is called constraint
In a file processing enviornment descrptions for data and application programs
the logic for accessing the data are built into
databases may be more expensive to maintain than files the need for specialized personnel
because of the complexity of the database environment
backup and reovery needs
which of the following is not a cost and risk of the database improved responsiveness
approach
A) specialized personnel
B) cost of conversion
C) improved responsiveness
D) organizational conflict
2/12
with answers.
One application of data warehouse is decision support
Older systems that often contain data of poor quality legacy
are called systems
A database that is an organized collection logically
relate
d data
Which of the following types of data can be stored in a voice, letters, numbers
database
Data processed in a way that increases a users information
knowledge is
Data that describe the properties of other data are none of the above
A) relationships
B) logical
C)physical
D) none of the above
All of the following are properties of metadata except processing logic
A) data definitions
B) processing logic
C) rules or contraints
D) Data structures
one disadvantage of file processing system is limited data sharing
program data dependence is caused by file descriptors being stored in each application
because applications are often developed independently unpanned duplicate data files are the rule rather than the exception
in file processing systems
Organizations that utilize the file processing approach 80%
spend as much as of their IS development budget
on maintenance
A graphical system used to capture the nature and data model
relationships among data is
A person place an object an event or concept about entity
which the organization wishes to maintain data is called
1/12
, are established between entities in a well relationships
structured database so that the desired information can
be retrieved
Relational databases establish the relationships between relation
entities by means of common fields included in a file called
All of the follwoing are primary purposes of database providing an integrated development environment
management system except
An is developed by identifying a form or report user view
that a user needs on a regular basis
With the database approach, data description are stored repository
in a central location known as
A user is a logical description of some portion of the database
which organizational function should set database none of the above
standards
A) management
B) Application development
C) technical services
D) none of the above
is a tool even non programers can use to access Structured query language
information from a database
Which of the following is not an advantage of a database redundant data
system
the most common source of database failures in failure to implement a strong database administration function
organization is
a rule that cannot be violated by database users is called constraint
In a file processing enviornment descrptions for data and application programs
the logic for accessing the data are built into
databases may be more expensive to maintain than files the need for specialized personnel
because of the complexity of the database environment
backup and reovery needs
which of the following is not a cost and risk of the database improved responsiveness
approach
A) specialized personnel
B) cost of conversion
C) improved responsiveness
D) organizational conflict
2/12
