Databases Exam – Complete Study Guide with Practice
Questions.
One application of data warehouse is decision support
Older systems that often contain data of poor legacy
quality 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 voice, letters, numbers
a 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)physica
l
D) none of the above
All of the following are properties of metadata processing logic
except
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 unpanned duplicate data files are the rule rather than the exception
independently in file processing systems
Organizations that utilize the file processing 80%
approach 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
1/13
, A person place an object an event or concept about entity
which the organization wishes to maintain data is
called
are established between entities in a well relationships
structured database so that the desired
information can be retrieved
Relational databases establish the relationships relation
between 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 user view
report that a user needs on a regular basis
With the database approach, data description are repository
stored in a central location known as
A user is a logical description of some portion of the database
which organizational function should set none of the above
database standards
A) management
B) Application development
C) technical services
D) none of the above
is a tool even non programers can use to Structured query language
access information from a database
Which of the following is not an advantage of a redundant data
database 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 constraint
called
In a file processing enviornment descrptions for application programs
data and the logic for accessing the data are built
into
databases may be more expensive to maintain than the need for specialized personnel
files because of the complexity of the database
environment backup and reovery needs
2/13
Questions.
One application of data warehouse is decision support
Older systems that often contain data of poor legacy
quality 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 voice, letters, numbers
a 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)physica
l
D) none of the above
All of the following are properties of metadata processing logic
except
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 unpanned duplicate data files are the rule rather than the exception
independently in file processing systems
Organizations that utilize the file processing 80%
approach 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
1/13
, A person place an object an event or concept about entity
which the organization wishes to maintain data is
called
are established between entities in a well relationships
structured database so that the desired
information can be retrieved
Relational databases establish the relationships relation
between 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 user view
report that a user needs on a regular basis
With the database approach, data description are repository
stored in a central location known as
A user is a logical description of some portion of the database
which organizational function should set none of the above
database standards
A) management
B) Application development
C) technical services
D) none of the above
is a tool even non programers can use to Structured query language
access information from a database
Which of the following is not an advantage of a redundant data
database 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 constraint
called
In a file processing enviornment descrptions for application programs
data and the logic for accessing the data are built
into
databases may be more expensive to maintain than the need for specialized personnel
files because of the complexity of the database
environment backup and reovery needs
2/13
