Question 1

Which of the following is NOT a cost and/or risk of the database approach?

Accepted Answer

A)  Specialized personnel 
B)  Cost of conversion 
C)  Improved responsiveness 
D)  Organizational conflict 
A)  Specialized personnel 
B)  Cost of conversion 
C)  Improved responsiveness 
D)  Organizational conflict C

Question 2

A data model is a graphical system used to capture the nature and relationships among data,

Accepted Answer

A) True 
 B)False  True

Question 3

Databases are an organized collection of ________ data.

Accepted Answer

logically related

Question 4

Which organizational function should set database standards?

Accepted Answer

A)  Management 
B)  Application development 
C)  Technical services 
D)  None of the above 
A)  Management 
B)  Application development 
C)  Technical services 
D)  None of the above

Question 5

The systems development life cycle is the traditional methodology used to develop,maintain,and replace information systems.

Accepted Answer

A) True 
 B)False

Question 6

Each member of a workgroup accesses data located on a database server.

Accepted Answer

A) True 
 B)False

Question 7

The need for consensus on data definitions is an example of which type of risk in the database environment?

Accepted Answer

A)  Specialized personnel needs 
B)  Organizational conflict 
C)  Conversion costs 
D)  Legacy systems 
A)  Specialized personnel needs 
B)  Organizational conflict 
C)  Conversion costs 
D)  Legacy systems

Question 8

Databases were developed as the first application of computers to data processing.

Accepted Answer

A) True 
 B)False

Question 9

A data warehouse derives its data from:

Accepted Answer

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

Question 10

The term legacy system refers to a newly installed database management system.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT an objective that drove the development and evolution of database technology?

Accepted Answer

A)  The need to provide greater independence between programs and data 
B)  The desire to manage increasing complex data types and structures 
C)  The desire to require programmers to write all file handling functionality 
D)  The need to provide ever more powerful platforms for decision support applications 
A)  The need to provide greater independence between programs and data 
B)  The desire to manage increasing complex data types and structures 
C)  The desire to require programmers to write all file handling functionality 
D)  The need to provide ever more powerful platforms for decision support applications

Question 12

________ concentrate on determining the requirements for the database component of an information system.

Accepted Answer

A)  Database analysts 
B)  Systems analysts 
C)  Programmers 
D)  All of the above 
A)  Database analysts 
B)  Systems analysts 
C)  Programmers 
D)  All of the above

Question 13

Which of the following is software used to create,maintain,and provide controlled access to databases?

Accepted Answer

A)  Network operating system 
B)  User view 
C)  Database management system 
D)  Attribute 
A)  Network operating system 
B)  User view 
C)  Database management system 
D)  Attribute

Question 14

________ integrates all functions of the enterprise,such as marketing,sales,finance,inventory,accounting,and human resources.

Accepted Answer

Enterprise

Question 15

Databases may be more expensive to maintain than files because of:

Accepted Answer

A)  the need for specialized personnel. 
B)  the complexity of the database environment. 
C)  backup and recovery needs. 
D)  all of the above. 
A)  the need for specialized personnel. 
B)  the complexity of the database environment. 
C)  backup and recovery needs. 
D)  all of the above.

Question 16

________ databases are designed to support one user.

Accepted Answer

The answer of ________ databases are designed to support one...

Question 17

Facts,text,graphic images,sound,and video segments that have meaning in the user's new environment are called ________.

Accepted Answer

The answer of Facts,text,graphic images,sound,and video segments that have meaning...

Question 18

The conceptual schema is always technology specific.

Accepted Answer

A) True 
 B)False

Question 19

The period that can be considered a "proof of concept" time was the:

Accepted Answer

A)  1950s. 
B)  1960s. 
C)  1970s. 
D)  1990s. 
A)  1950s. 
B)  1960s. 
C)  1970s. 
D)  1990s.

Question 20

Discuss who is involved in the database development process.

Accepted Answer

There are many different types of indivi

Which of the following is NOT a cost and/or risk of the database approach?

A data model is a graphical system used to capture the nature and relationships among data,

Databases are an organized collection of ________ data.

Which organizational function should set database standards?

The systems development life cycle is the traditional methodology used to develop,maintain,and replace information systems.

Each member of a workgroup accesses data located on a database server.

The need for consensus on data definitions is an example of which type of risk in the database environment?

Databases were developed as the first application of computers to data processing.

A data warehouse derives its data from:

The term legacy system refers to a newly installed database management system.

Which of the following is NOT an objective that drove the development and evolution of database technology?

________ concentrate on determining the requirements for the database component of an information system.

Which of the following is software used to create,maintain,and provide controlled access to databases?

________ integrates all functions of the enterprise,such as marketing,sales,finance,inventory,accounting,and human resources.

Databases may be more expensive to maintain than files because of:

________ databases are designed to support one user.

Facts,text,graphic images,sound,and video segments that have meaning in the user's new environment are called ________.

The conceptual schema is always technology specific.

The period that can be considered a "proof of concept" time was the:

Discuss who is involved in the database development process.

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 1: The Database Environment and Development Process

Which of the following is NOT a cost and/or risk of the database approach?

A data model is a graphical system used to capture the nature and relationships among data,

Databases are an organized collection of ________ data.

Which organizational function should set database standards?

The systems development life cycle is the traditional methodology used to develop,maintain,and replace information systems.

Each member of a workgroup accesses data located on a database server.

The need for consensus on data definitions is an example of which type of risk in the database environment?

Databases were developed as the first application of computers to data processing.

A data warehouse derives its data from:

The term legacy system refers to a newly installed database management system.

Which of the following is NOT an objective that drove the development and evolution of database technology?

________ concentrate on determining the requirements for the database component of an information system.

Which of the following is software used to create,maintain,and provide controlled access to databases?

________ integrates all functions of the enterprise,such as marketing,sales,finance,inventory,accounting,and human resources.

Databases may be more expensive to maintain than files because of:

________ databases are designed to support one user.

Facts,text,graphic images,sound,and video segments that have meaning in the user's new environment are called ________.

The conceptual schema is always technology specific.

The period that can be considered a "proof of concept" time was the:

Discuss who is involved in the database development process.

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters