Question 1

The external schema contains a subset of the conceptual schema relevant to a particular group of users.

Accepted Answer

A) True 
 B)False

Question 2

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 3

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.

Accepted Answer

A) True 
 B)False

Question 4

Reduced program maintenance is an advantage of file processing systems.

Accepted Answer

A) True 
 B)False

Question 5

A user view is how the user sees the data when it is produced.

Accepted Answer

A) True 
 B)False

Question 6

Provide a brief overview of the various components of the database environment

Accepted Answer

Components of the database environment i

Question 7

One disadvantage of file processing systems is:

Accepted Answer

A)  reduced data duplication. 
B)  program-data independence. 
C)  limited data sharing. 
D)  enforcement of integrity constraints. 
A)  reduced data duplication. 
B)  program-data independence. 
C)  limited data sharing. 
D)  enforcement of integrity constraints.

Question 8

A(n)________ is a rule that cannot be violated by the database users.

Accepted Answer

The answer of A(n)________ is a rule that cannot be...

Question 9

A(n)________ is a separate database that contains summarized and historical information.

Accepted Answer

The answer of A(n)________ is a separate database that contains...

Question 10

Data processed in a way that increases a user's knowledge is:

Accepted Answer

A)  text. 
B)  graphics 
C)  information. 
D)  hyperlink. 
A)  text. 
B)  graphics 
C)  information. 
D)  hyperlink.

Question 11

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.

Accepted Answer

A) True 
 B)False

Question 12

Prototyping is a type of rapid application development.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following will interfere with access to operational databases?

Accepted Answer

A)  Unstructured and unpredictable use of data 
B)  Predictable use of data 
C)  Efficient transaction processing systems 
D)  All of the above 
A)  Unstructured and unpredictable use of data 
B)  Predictable use of data 
C)  Efficient transaction processing systems 
D)  All of the above

Question 14

The first step in database development,in which the scope and general contents of databases are specified,is called ________.

Accepted Answer

enterprise

Question 15

A data warehouse contains summarized and historical information.

Accepted Answer

A) True 
 B)False

Question 16

In prototyping,implementation and maintenance activities are repeated as necessary until the product is correct.

Accepted Answer

A) True 
 B)False

Question 17

An entity is a person,place,object,________ or concept in the user environment.

Accepted Answer

The answer of An entity is a person,place,object,________ or concept...

Question 18

The SDLC phase in which database processing programs are created is the ________ phase.

Accepted Answer

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

Question 19

Organizational commitment to a database project is not necessary for its success.

Accepted Answer

A) True 
 B)False

Question 20

Metadata are data that describe the properties of other data.

Accepted Answer

A) True 
 B)False

The external schema contains a subset of the conceptual schema relevant to a particular group of users.

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

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.

Reduced program maintenance is an advantage of file processing systems.

A user view is how the user sees the data when it is produced.

Provide a brief overview of the various components of the database environment

One disadvantage of file processing systems is:

A(n)________ is a rule that cannot be violated by the database users.

A(n)________ is a separate database that contains summarized and historical information.

Data processed in a way that increases a user's knowledge is:

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.

Prototyping is a type of rapid application development.

Which of the following will interfere with access to operational databases?

The first step in database development,in which the scope and general contents of databases are specified,is called ________.

A data warehouse contains summarized and historical information.

In prototyping,implementation and maintenance activities are repeated as necessary until the product is correct.

An entity is a person,place,object,________ or concept in the user environment.

The SDLC phase in which database processing programs are created is the ________ phase.

Organizational commitment to a database project is not necessary for its success.

Metadata are data that describe the properties of other data.

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 external schema contains a subset of the conceptual schema relevant to a particular group of users.

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

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.

Reduced program maintenance is an advantage of file processing systems.

A user view is how the user sees the data when it is produced.

Provide a brief overview of the various components of the database environment

One disadvantage of file processing systems is:

A(n)________ is a rule that cannot be violated by the database users.

A(n)________ is a separate database that contains summarized and historical information.

Data processed in a way that increases a user's knowledge is:

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.

Prototyping is a type of rapid application development.

Which of the following will interfere with access to operational databases?

The first step in database development,in which the scope and general contents of databases are specified,is called ________.

A data warehouse contains summarized and historical information.

In prototyping,implementation and maintenance activities are repeated as necessary until the product is correct.

An entity is a person,place,object,________ or concept in the user environment.

The SDLC phase in which database processing programs are created is the ________ phase.

Organizational commitment to a database project is not necessary for its success.

Metadata are data that describe the properties of other data.

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