Question 1

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 2

Database management involves all of the following EXCEPT:

Accepted Answer

A)  collecting data. 
B)  organizing data. 
C)  design web pages. 
D)  managing data. 
A)  collecting data. 
B)  organizing data. 
C)  design web pages. 
D)  managing data.

Question 3

Metatdata typically describes all of the following EXCEPT:

Accepted Answer

A)  data definitions. 
B)  length. 
C)  allowable values. 
D)  location on disk. 
A)  data definitions. 
B)  length. 
C)  allowable values. 
D)  location on disk.

Question 4

Discuss some of the advantages to the database approach.

Accepted Answer

The database approach has several advant

Question 5

A well-structured database establishes the entities between relationships in order to derive the desired information.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Information is processed data.

Accepted Answer

A) True 
 B)False

Question 8

Metadata are data that describe the properties of other data.

Accepted Answer

A) True 
 B)False

Question 9

Database architects establish standards for data in business units.

Accepted Answer

A) True 
 B)False

Question 10

Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.

Accepted Answer

A) True 
 B)False

Question 11

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 (DBMS) 
D)  Attribute 
A)  Network operating system 
B)  User view 
C)  Database management system (DBMS) 
D)  Attribute

Question 12

One of the most popular RAD methods is:

Accepted Answer

A)  automated design. 
B)  structured walkthrough. 
C)  prototyping. 
D)  crafting. 
A)  automated design. 
B)  structured walkthrough. 
C)  prototyping. 
D)  crafting.

Question 13

Discuss big data and data warehousing. How is it different from operational systems?

Accepted Answer

Data warehousing systems use static data

Question 14

Discuss some of the disadvantages of file processing systems.

Accepted Answer

File processing systems have several dis

Question 15

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

Accepted Answer

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

Question 16

Program-data dependence is caused by:

Accepted Answer

A)  file descriptions being stored in each database application. 
B)  data descriptions being stored on a server. 
C)  data descriptions being written into programming code. 
D)  data cohabiting with programs. 
A)  file descriptions being stored in each database application. 
B)  data descriptions being stored on a server. 
C)  data descriptions being written into programming code. 
D)  data cohabiting with programs.

Question 17

A data warehouse contains summarized and historical information.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Legacy systems often contain data of ________ quality and are generally hosted on ________.

Accepted Answer

A)  poor; personal computers 
B)  excellent; mainframes 
C)  poor; mainframes 
D)  excellent; workgroup computers 
A)  poor; personal computers 
B)  excellent; mainframes 
C)  poor; mainframes 
D)  excellent; workgroup computers

Question 20

A constraint is a rule in a database system that can be violated by users.

Accepted Answer

A) True 
 B)False

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

Database management involves all of the following EXCEPT:

Metatdata typically describes all of the following EXCEPT:

Discuss some of the advantages to the database approach.

A well-structured database establishes the entities between relationships in order to derive the desired information.

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

Information is processed data.

Metadata are data that describe the properties of other data.

Database architects establish standards for data in business units.

Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.

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

One of the most popular RAD methods is:

Discuss big data and data warehousing. How is it different from operational systems?

Discuss some of the disadvantages of file processing systems.

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

Program-data dependence is caused by:

A data warehouse contains summarized and historical information.

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

Legacy systems often contain data of quality and are generally hosted on .

A constraint is a rule in a database system that can be violated by users.

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

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

Database management involves all of the following EXCEPT:

Metatdata typically describes all of the following EXCEPT:

Discuss some of the advantages to the database approach.

A well-structured database establishes the entities between relationships in order to derive the desired information.

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

Information is processed data.

Metadata are data that describe the properties of other data.

Database architects establish standards for data in business units.

Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.

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

One of the most popular RAD methods is:

Discuss big data and data warehousing. How is it different from operational systems?

Discuss some of the disadvantages of file processing systems.

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

Program-data dependence is caused by:

A data warehouse contains summarized and historical information.

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

Legacy systems often contain data of ________ quality and are generally hosted on ________.

A constraint is a rule in a database system that can be violated by users.

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

Legacy systems often contain data of quality and are generally hosted on .