Exam 1: The Database Environment and Development Process

Information is processed data.

Languages,menus,and other facilities by which users interact with the database are collectively called a(n):

Which of the following is an integrated decision support database with content derived from various operational databases?

A modern database management system automates more of the backup and recovery tasks than a file system.

Program-data dependence is caused by:

________ are used for decision support applications.

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

A repository contains ________ of data whereas a database contains ________ of data.

A graphical system used to capture the nature and relationships among data is called a(n):

An enterprise resource planning system integrates all functions of the enterprise.

With the traditional file processing approach,each application shares data files,thus enabling much data sharing.

Discuss some of the advantages to the database approach.

Data redundancy is used to establish relationships between data but is never used to improve database performance.

Cost and complexity are just two of the disadvantages of database processing.

One application of data warehouses is:

A rule that CANNOT be violated by database users is called a:

Database architects establish standards for data in business units.

Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.

The user interface includes languages,menus,and other facilities by which users interact with various system components.