Question 1

The most common source of database failures in organizations is:

Accepted Answer

A)  lack of planning. 
B)  inadequate budget. 
C)  inadequate hardware. 
D)  failure to implement a strong database administration function.

Question 2

Cost and complexity are just two of the disadvantages of database processing.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Personal databases are designed to support a small group of individuals working together on a project.

Accepted Answer

A) True 
 B)False

Question 5

Enterprise modeling sets the range and general contents of organizational databases.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Data management technologies are also increasing often used as information systems, as a foundation for analytics or the systematic analysis of data to understand a real-world problem better.

Accepted Answer

A) True 
 B)False

Question 8

One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer.

Accepted Answer

A) True 
 B)False

Question 9

Specifying how data from a logical schema are stored in secondary memory is part of the:

Accepted Answer

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

Question 10

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 11

Multi-tier client/server database applications contain a business logic layer.

Accepted Answer

A) True 
 B)False

Question 12

E. F. Codd developed the relational data model during the 1970s.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Languages, menus, and other facilities by which users interact with the database are collectively called a(n):

Accepted Answer

A)  client. 
B)  user interface. 
C)  icon. 
D)  development environment.

Question 15

A departmental multi-tiered client/server database is stored on a central device called a:

Accepted Answer

A)  client. 
B)  server. 
C)  remote PC. 
D)  network.

Question 16

Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.

Accepted Answer

A) True 
 B)False

Question 17

The steps of the systems development life cycle can only be viewed as a linear process.

Accepted Answer

A) True 
 B)False

Question 18

Database development begins with the design of the database.

Accepted Answer

A) True 
 B)False

Question 19

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

Accepted Answer

A) True 
 B)False

Question 20

A major difference between data warehouses and transactional systems as compared to big data is:

Accepted Answer

A)  the data is unstructured in big data systems. 
B)  the size of the CPU used. 
C)  the programming required to access data. 
D)  all of the above.

Exam 1: The Database Environment and Development Process

The most common source of database failures in organizations is:

Cost and complexity are just two of the disadvantages of database processing.

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

Personal databases are designed to support a small group of individuals working together on a project.

Enterprise modeling sets the range and general contents of organizational databases.

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

Data management technologies are also increasing often used as information systems, as a foundation for analytics or the systematic analysis of data to understand a real-world problem better.

One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer.

Specifying how data from a logical schema are stored in secondary memory is part of the:

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

Multi-tier client/server database applications contain a business logic layer.

E. F. Codd developed the relational data model during the 1970s.

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

Languages, menus, and other facilities by which users interact with the database are collectively called a(n) :

A departmental multi-tiered client/server database is stored on a central device called a:

Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.

The steps of the systems development life cycle can only be viewed as a linear process.

Database development begins with the design of the database.

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

A major difference between data warehouses and transactional systems as compared to big data is: