Question 1

A data warehouse derives its data from:

Accepted Answer

A)  on-line transactions. 
B)  various operational data sources. 
C)  reports. 
D)  a data mart. 
A)  on-line transactions. 
B)  various operational data sources. 
C)  reports. 
D)  a data mart.

Question 2

Reduced program maintenance is an advantage of file processing systems.

Accepted Answer

A) True 
 B)False

Question 3

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

Accepted Answer

A) True 
 B)False

Question 4

Unplanned duplicate data files are the rule rather than the exception in file processing systems.

Accepted Answer

A) True 
 B)False

Question 5

Although personal databases improve productivity, one risk is that data cannot be shared with other users.

Accepted Answer

A) True 
 B)False

Question 6

Redundancy increases the risk of inconsistent data.

Accepted Answer

A) True 
 B)False

Question 7

________ specify computer systems requirements.

Accepted Answer

A)  Programmers 
B)  Users 
C)  Systems analysts 
D)  Database analysts 
A)  Programmers 
B)  Users 
C)  Systems analysts 
D)  Database analysts

Question 8

Which organizational function should set database standards?

Accepted Answer

A)  Management 
B)  Application development 
C)  Technical services 
D)  Database Administration 
A)  Management 
B)  Application development 
C)  Technical services 
D)  Database Administration

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:

Accepted Answer

A)  CASE. 
B)  CAD. 
C)  RAD. 
D)  MST. 
A)  CASE. 
B)  CAD. 
C)  RAD. 
D)  MST.

Question 11

Visual programming tools such as Visual Basic have made prototyping more difficult.

Accepted Answer

A) True 
 B)False

Question 12

Discuss Enterprise Resource Planning Systems, and contrast these to data warehouses.

Accepted Answer

An ERP system integrates all functions o

Question 13

________ are established between entities in a well-structured database so that the desired information can be retrieved.

Accepted Answer

A)  Entities 
B)  Relationships 
C)  Lines 
D)  Ties 
A)  Entities 
B)  Relationships 
C)  Lines 
D)  Ties

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is NOT an advantage of database systems?

Accepted Answer

A)  Redundant data 
B)  Program-data independence 
C)  Better data quality 
D)  Reduced program maintenance 
A)  Redundant data 
B)  Program-data independence 
C)  Better data quality 
D)  Reduced program maintenance

Question 16

Data that describe the properties of other data are:

Accepted Answer

A)  relationships. 
B)  logical. 
C)  physical. 
D)  metadata. 
A)  relationships. 
B)  logical. 
C)  physical. 
D)  metadata.

Question 17

The most common way to support a group of individuals who work together on a project or group of similar projects is with a multi-tier client/server database.

Accepted Answer

A) True 
 B)False

Question 18

With the database approach, data descriptions are stored in a central location known as a:

Accepted Answer

A)  server. 
B)  mainframe. 
C)  PC. 
D)  repository. 
A)  server. 
B)  mainframe. 
C)  PC. 
D)  repository.

Question 19

A user view is:

Accepted Answer

A)  what a user sees when he or she looks out the window. 
B)  a table or set of tables. 
C)  a logical description of some portion of the database. 
D)  a procedure stored on the server. 
A)  what a user sees when he or she looks out the window. 
B)  a table or set of tables. 
C)  a logical description of some portion of the database. 
D)  a procedure stored on the server.

Question 20

Discuss why alternative IS development approaches have evolved, and provide an overview of a couple of these methodologies.

Accepted Answer

The SDLC is often criticized for being t

A data warehouse derives its data from:

Reduced program maintenance is an advantage of file processing systems.

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

Unplanned duplicate data files are the rule rather than the exception in file processing systems.

Although personal databases improve productivity, one risk is that data cannot be shared with other users.

Redundancy increases the risk of inconsistent data.

________ specify computer systems requirements.

Which organizational function should set database standards?

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

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:

Visual programming tools such as Visual Basic have made prototyping more difficult.

Discuss Enterprise Resource Planning Systems, and contrast these to data warehouses.

________ are established between entities in a well-structured database so that the desired information can be retrieved.

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

Which of the following is NOT an advantage of database systems?

Data that describe the properties of other data are:

The most common way to support a group of individuals who work together on a project or group of similar projects is with a multi-tier client/server database.

With the database approach, data descriptions are stored in a central location known as a:

A user view is:

Discuss why alternative IS development approaches have evolved, and provide an overview of a couple of these methodologies.

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 1: The Database Environment and Development Process

A data warehouse derives its data from:

Reduced program maintenance is an advantage of file processing systems.

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

Unplanned duplicate data files are the rule rather than the exception in file processing systems.

Although personal databases improve productivity, one risk is that data cannot be shared with other users.

Redundancy increases the risk of inconsistent data.

________ specify computer systems requirements.

Which organizational function should set database standards?

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

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:

Visual programming tools such as Visual Basic have made prototyping more difficult.

Discuss Enterprise Resource Planning Systems, and contrast these to data warehouses.

________ are established between entities in a well-structured database so that the desired information can be retrieved.

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

Which of the following is NOT an advantage of database systems?

Data that describe the properties of other data are:

The most common way to support a group of individuals who work together on a project or group of similar projects is with a multi-tier client/server database.

With the database approach, data descriptions are stored in a central location known as a:

A user view is:

Discuss why alternative IS development approaches have evolved, and provide an overview of a couple of these methodologies.

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters