Question 1

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

Accepted Answer

Variable-l...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4GLsE) None of the above
F) C) and D)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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.E) A) and B)
F) A) and C)

Question 7

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)   selectE) B) and D)
F) B) and C)

Question 8

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 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.E) All of the above
F) A) and D)

Question 10

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 processE) A) and B)
F) A) and D)

Question 11

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

Accepted Answer

ad hoc requests

Question 12

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 13

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 designsE) A) and C)
F) A) and D)

Question 14

DBMS packages play a major role in application development.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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 dataE) A) and B)
F) B) and D)

Question 18

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 19

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 20

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 reliableE) A) and C)
F) B) and D)

Exam 5: Data Resource Management

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

Correct AnswerverifiedVariable-l...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The database maintenance process is accomplished via:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The physical design stage of database development:

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedad hoc requests

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

DBMS packages play a major role in application development.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
Variable-l...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
ad hoc requests

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified