Question 1

The SDLC phase in which the detailed conceptual data model is created is the ________ phase.

Accepted Answer

A)  planning 
B)  design 
C)  analysis 
D)  implementation 
A)  planning 
B)  design 
C)  analysis 
D)  implementation

Question 2

Organizing the database in computer disk storage is done in the ________ phase.

Accepted Answer

A)  design 
B)  maintenance 
C)  analysis 
D)  implementation 
A)  design 
B)  maintenance 
C)  analysis 
D)  implementation

Question 3

When a traditional file-processing system is developed,there is very little opportunity to ________ previous development efforts.

Accepted Answer

The answer of When a traditional file-processing system is developed,there...

Question 4

In practice,databases today may contain either data or information.

Accepted Answer

A) True 
 B)False

Question 5

Multitier client/server database applications contain a business logic layer.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Database development begins with ________,which establishes the range and general contents of organizational databases.

Accepted Answer

A)  database design 
B)  cross-functional analysis 
C)  departmental data modeling 
D)  enterprise data modeling 
A)  database design 
B)  cross-functional analysis 
C)  departmental data modeling 
D)  enterprise data modeling

Question 8

A(n)________ supports organization-wide operations and decisions.

Accepted Answer

The answer of A(n)________ supports organization-wide operations and decisions....

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

Repositories are always used in file processing systems.

Accepted Answer

A) True 
 B)False

Question 12

A ________ is software which creates,maintains and controls access to databases.

Accepted Answer

database m

Question 13

A(n)________ is a small group of people collaborating on a project.

Accepted Answer

The answer of A(n)________ is a small group of people...

Question 14

Unplanned and uncontrolled ________ can often lead to a loss of metadata integrity.

Accepted Answer

The answer of Unplanned and uncontrolled ________ can often lead...

Question 15

End users can often retrieve and display data easily with a relational database

Accepted Answer

A) True 
 B)False

Question 16

A knowledge base of information on facts about an enterprise is called a(n):

Accepted Answer

A)  enterprise information system. 
B)  repository. 
C)  systems information unit. 
D)  database process. 
A)  enterprise information system. 
B)  repository. 
C)  systems information unit. 
D)  database process.

Question 17

CASE is a class of tools that:

Accepted Answer

A)  assists the database administrator in maintaining a database. 
B)  provides guidelines for the physical design of a database. 
C)  provides management reporting tools. 
D)  automates the design of databases and application programs. 
A)  assists the database administrator in maintaining a database. 
B)  provides guidelines for the physical design of a database. 
C)  provides management reporting tools. 
D)  automates the design of databases and application programs.

Question 18

Discuss some of the disadvantages of file processing systems.

Accepted Answer

File processing systems have several dis

Question 19

The ________ is the view of managers and other employees who are the database users.

Accepted Answer

The answer of The ________ is the view of managers...

Question 20

In two-tier database architectures,little functionality needs to be programmed into the client application.

Accepted Answer

A) True 
 B)False

The SDLC phase in which the detailed conceptual data model is created is the ________ phase.

Organizing the database in computer disk storage is done in the ________ phase.

When a traditional file-processing system is developed,there is very little opportunity to ________ previous development efforts.

In practice,databases today may contain either data or information.

Multitier client/server database applications contain a business logic layer.

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

Database development begins with ________,which establishes the range and general contents of organizational databases.

A(n)________ supports organization-wide operations and decisions.

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

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

Repositories are always used in file processing systems.

A ________ is software which creates,maintains and controls access to databases.

A(n)________ is a small group of people collaborating on a project.

Unplanned and uncontrolled ________ can often lead to a loss of metadata integrity.

End users can often retrieve and display data easily with a relational database

A knowledge base of information on facts about an enterprise is called a(n):

CASE is a class of tools that:

Discuss some of the disadvantages of file processing systems.

The ________ is the view of managers and other employees who are the database users.

In two-tier database architectures,little functionality needs to be programmed into the client application.

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

The SDLC phase in which the detailed conceptual data model is created is the ________ phase.

Organizing the database in computer disk storage is done in the ________ phase.

When a traditional file-processing system is developed,there is very little opportunity to ________ previous development efforts.

In practice,databases today may contain either data or information.

Multitier client/server database applications contain a business logic layer.

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

Database development begins with ________,which establishes the range and general contents of organizational databases.

A(n)________ supports organization-wide operations and decisions.

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

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

Repositories are always used in file processing systems.

A ________ is software which creates,maintains and controls access to databases.

A(n)________ is a small group of people collaborating on a project.

Unplanned and uncontrolled ________ can often lead to a loss of metadata integrity.

End users can often retrieve and display data easily with a relational database

A knowledge base of information on facts about an enterprise is called a(n):

CASE is a class of tools that:

Discuss some of the disadvantages of file processing systems.

The ________ is the view of managers and other employees who are the database users.

In two-tier database architectures,little functionality needs to be programmed into the client application.

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