Question 1

Having data in independent files makes it easier to provide end users with information for ad hoc requests.

Accepted Answer

A) True 
 B)False  False

Question 2

A weakness in the network model is that it cannot handle _______________ for information.

Accepted Answer

ad hoc requests

Question 3

The project operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

Accepted Answer

A) True 
 B)False  True

Question 4

Database administrators and database design analysts work with end users and systems analysts to do all of the following except:

Accepted Answer

A)   Model business processes and the data they require
B)   Determine what data definitions should be included in the database
C)   Determine what structure or relationships should exist among the data elements
D)   Enter live data into the system until it has proven to be reliable

Question 5

According to the textbook case, file processing in Hadoop is not halted by hardware failures because _______________.

Accepted Answer

A)   Hadoop is a software product
B)   Open-source products are not affected by hardware failures
C)   Hadoop is an Internet product and does not need hardware
D)   Hadoop keeps three (3)  copies of all data

Question 6

Distributed databases require fewer resources when it comes to computing power and bandwidth.

Accepted Answer

A) True 
 B)False

Question 7

A data model serves as a logical framework on which to base the physical design of a database.

Accepted Answer

A) True 
 B)False

Question 8

Object technology allows designers to do all of the following except:

Accepted Answer

A)   Develop product designs
B)   Replicate product designs and then modify them to create new product designs
C)   Save designs as objects in an object-oriented database
D)   Substantially reduce the file size of designs

Question 9

In mainframe and server computer systems, the database management system controls the _______________ of the databases of computer-using organizations.

Accepted Answer

A)   maintenance
B)   development
C)   use
D)   All of the choices are correct.

Question 10

Files are frequently classified by the application for which they are primarily used, such as a payroll file or an inventory file.

Accepted Answer

A) True 
 B)False

Question 11

Using a relational database, a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table. This is the _______________ operation.

Accepted Answer

A)   join
B)   link
C)   merge
D)   select

Question 12

Which of the following is a legitimate use for data mining?

Accepted Answer

A)   Performing "market-basket analysis" to identify new product bundles
B)   Profiling customers
C)   Finding the root cause of a quality or manufacturing problem
D)   All of the choices are correct.

Question 13

DBMS packages play a major role in application development.

Accepted Answer

A) True 
 B)False

Question 14

Databases contain data elements that describe both entities and the relationships among entities.

Accepted Answer

A) True 
 B)False

Question 15

A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.

Accepted Answer

A) True 
 B)False

Question 16

The multidimensional database structure is considered one of the key technologies of a new generation of Web-based applications.

Accepted Answer

A) True 
 B)False

Question 17

_______________ contain both a variable number of fields and variable field lengths.

Accepted Answer

The answer of _______________ contain both a variable number of...

Question 18

The _______________ operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

Accepted Answer

The answer of The _______________ operation is used to create...

Question 19

The physical design stage of database development:

Accepted Answer

A)   Develops a model of business processes
B)   Translates conceptual models into the data models
C)   Determines the data storage structures and access methods
D)   Defines the information needs of end users in a business process

Question 20

The database maintenance process is accomplished via:

Accepted Answer

A)   Hierarchical database systems that provide flexibility and network databases
B)   Transaction processing systems and other end user applications, with the support of the DBMS
C)   Graphical query languages correctly phrasing SQL
D)   File processing systems with the support of 4GLs

Exam 5: Data Resource Management

Having data in independent files makes it easier to provide end users with information for ad hoc requests.

A weakness in the network model is that it cannot handle _______________ for information.

The project operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

Database administrators and database design analysts work with end users and systems analysts to do all of the following except:

According to the textbook case, file processing in Hadoop is not halted by hardware failures because _______________.

Distributed databases require fewer resources when it comes to computing power and bandwidth.

A data model serves as a logical framework on which to base the physical design of a database.

Object technology allows designers to do all of the following except:

In mainframe and server computer systems, the database management system controls the _______________ of the databases of computer-using organizations.

Files are frequently classified by the application for which they are primarily used, such as a payroll file or an inventory file.

Using a relational database, a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table. This is the _______________ operation.

Which of the following is a legitimate use for data mining?

DBMS packages play a major role in application development.

Databases contain data elements that describe both entities and the relationships among entities.

A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.

The multidimensional database structure is considered one of the key technologies of a new generation of Web-based applications.

_______________ contain both a variable number of fields and variable field lengths.

The _______________ operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

The physical design stage of database development:

The database maintenance process is accomplished via: