Question 1

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

Accepted Answer

A)  40 percent 
B)  25 percent 
C)  60 percent 
D)  80 percent 
A)  40 percent 
B)  25 percent 
C)  60 percent 
D)  80 percent

Question 2

The traditional methodology used to develop, maintain, and replace information systems is called the:

Accepted Answer

A)  Enterprise Resource Model. 
B)  Systems Development Life Cycle. 
C)  Unified Model. 
D)  Systems Deployment Life Cycle. 
A)  Enterprise Resource Model. 
B)  Systems Development Life Cycle. 
C)  Unified Model. 
D)  Systems Deployment Life Cycle.

Question 3

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

Accepted Answer

A)  creating data. 
B)  updating data. 
C)  storing data. 
D)  providing an integrated development environment. 
A)  creating data. 
B)  updating data. 
C)  storing data. 
D)  providing an integrated development environment.

Question 4

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 5

In 1998, ANSI/SPARC published an import document describing the three-schema architecture.

Accepted Answer

A) True 
 B)False

Question 6

The three-schema approach includes which of the following schemas?

Accepted Answer

A)  Internal 
B)  Logical 
C)  Cross-functional 
D)  Dissecting 
A)  Internal 
B)  Logical 
C)  Cross-functional 
D)  Dissecting

Question 7

The internal schema consists of the physical schema and the enterprise data model.

Accepted Answer

A) True 
 B)False

Question 8

Discuss some of the costs associated with the database approach.

Accepted Answer

The database approach does not come with

Question 9

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

Accepted Answer

Components of the database environment i

Question 10

________ is a tool even non-programmers can use to access information from a database.

Accepted Answer

A)  ODBC 
B)  Structured query language 
C)  ASP 
D)  Data manipulation query language 
A)  ODBC 
B)  Structured query language 
C)  ASP 
D)  Data manipulation query language

Question 11

An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.

Accepted Answer

A) True 
 B)False

Question 12

E. F. Codd developed the relational model in the:

Accepted Answer

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

Question 13

The relational data model is no longer popular in the 21st century.

Accepted Answer

A) True 
 B)False

Question 14

Prototyping is a type of rapid application development.

Accepted Answer

A) True 
 B)False

Question 15

Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.

Accepted Answer

A) True 
 B)False

Question 16

The repository is populated during the analysis phase of the systems development life cycle.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

The conceptual schema is always technology specific.

Accepted Answer

A) True 
 B)False

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

The traditional methodology used to develop, maintain, and replace information systems is called the:

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

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

In 1998, ANSI/SPARC published an import document describing the three-schema architecture.

The three-schema approach includes which of the following schemas?

The internal schema consists of the physical schema and the enterprise data model.

Discuss some of the costs associated with the database approach.

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

________ is a tool even non-programmers can use to access information from a database.

An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.

E. F. Codd developed the relational model in the:

The relational data model is no longer popular in the 21^st century.

Prototyping is a type of rapid application development.

Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.

The repository is populated during the analysis phase of the systems development life cycle.

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

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

The conceptual schema is always technology specific.

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

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

The traditional methodology used to develop, maintain, and replace information systems is called the:

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

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

In 1998, ANSI/SPARC published an import document describing the three-schema architecture.

The three-schema approach includes which of the following schemas?

The internal schema consists of the physical schema and the enterprise data model.

Discuss some of the costs associated with the database approach.

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

________ is a tool even non-programmers can use to access information from a database.

An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.

E. F. Codd developed the relational model in the:

The relational data model is no longer popular in the 21st century.

Prototyping is a type of rapid application development.

Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.

The repository is populated during the analysis phase of the systems development life cycle.

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

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

The conceptual schema is always technology specific.

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

The relational data model is no longer popular in the 21^st century.