Question 1

Fixed-length records contain:

Accepted Answer

A)  both a variable number of fields and variable field lengths. 
B)  both a variable number of fields and fixed field lengths. 
C)  both a fixed number of fields and variable field lengths. 
D)  both a fixed number of fields and fixed field lengths. 
A)  both a variable number of fields and variable field lengths. 
B)  both a variable number of fields and fixed field lengths. 
C)  both a fixed number of fields and variable field lengths. 
D)  both a fixed number of fields and fixed field lengths. D

Question 2

Which of the following is true of data marts?

Accepted Answer

A)  They hold data from many different data warehouses. 
B)  They are a subset of a data warehouse. 
C)  They focus on many generalized aspects of a company. 
D)  None of the choices are correct. 
A)  They hold data from many different data warehouses. 
B)  They are a subset of a data warehouse. 
C)  They focus on many generalized aspects of a company. 
D)  None of the choices are correct. B

Question 3

The primary challenge of a distributed database is:

Accepted Answer

A)  Data accuracy 
B)  Data transmission speed 
C)  Storage costs 
D)  Data security 
A)  Data accuracy 
B)  Data transmission speed 
C)  Storage costs 
D)  Data security A

Question 4

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

A)  link 
B)  relate 
C)  project 
D)  merge 
A)  link 
B)  relate 
C)  project 
D)  merge

Question 5

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 6

Database administrators and designers work with corporate and end user management to develop an _______________ model that defines the basic business process of the enterprise.

Accepted Answer

The answer of Database administrators and designers work with corporate...

Question 7

When independent of any other files related to it, a single table is referred to as a(n):

Accepted Answer

A)  Independent file 
B)  Flat file 
C)  Hierarchical file 
D)  Non-variable file 
A)  Independent file 
B)  Flat file 
C)  Hierarchical file 
D)  Non-variable file

Question 8

A DBMS query language is designed to:

Accepted Answer

A)  Support information systems professionals in the development of complex application software 
B)  Support end users who wish to obtain ad hoc reports 
C)  Provide efficient batch mode processing of the database 
D)  Specify the content, relationships, and structure of a database 
A)  Support information systems professionals in the development of complex application software 
B)  Support end users who wish to obtain ad hoc reports 
C)  Provide efficient batch mode processing of the database 
D)  Specify the content, relationships, and structure of a database

Question 9

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. 
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 10

One drawback to the database duplication process is that no changes can ever be made to any database other than the master. Otherwise, local changes will be overwritten during the duplication process.

Accepted Answer

A) True 
 B)False

Question 11

Early mainframe DBMS packages used the _______________ structure, in which all records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.

Accepted Answer

A)  network 
B)  relational 
C)  hierarchical 
D)  object-oriented 
A)  network 
B)  relational 
C)  hierarchical 
D)  object-oriented

Question 12

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

Accepted Answer

The answer of The duplication process basically identifies one database...

Question 13

_______________ databases have become the most popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.

Accepted Answer

A)  Relational 
B)  Object-oriented 
C)  Inter-relational 
D)  Multidimensional 
A)  Relational 
B)  Object-oriented 
C)  Inter-relational 
D)  Multidimensional

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A data warehouse contains data that have been processed in all the following ways except:

Accepted Answer

A)  Separated 
B)  Cleaned 
C)  Transformed 
D)  Cataloged 
A)  Separated 
B)  Cleaned 
C)  Transformed 
D)  Cataloged

Question 16

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 
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 17

To solve the problems encountered with the file processing approach, the _______________ management approach was conceived. It is the foundation of modern methods of managing organizational data.

Accepted Answer

The answer of To solve the problems encountered with the...

Question 18

DBMS packages play a major role in application development.

Accepted Answer

A) True 
 B)False

Question 19

In all information systems, data resources must be organized and structured in some logical manner, so that they can be:

Accepted Answer

A)  Easily accessed 
B)  Processed efficiently 
C)  Retrieved quickly 
D)  All of the choices are correct. 
A)  Easily accessed 
B)  Processed efficiently 
C)  Retrieved quickly 
D)  All of the choices are correct.

Question 20

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

Accepted Answer

A) True 
 B)False

Fixed-length records contain:

Which of the following is true of data marts?

The primary challenge of a distributed database is:

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

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

Database administrators and designers work with corporate and end user management to develop an _______________ model that defines the basic business process of the enterprise.

When independent of any other files related to it, a single table is referred to as a(n):

A DBMS query language is designed to:

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

One drawback to the database duplication process is that no changes can ever be made to any database other than the master. Otherwise, local changes will be overwritten during the duplication process.

Early mainframe DBMS packages used the _______________ structure, in which all records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

_______________ databases have become the most popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.

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

A data warehouse contains data that have been processed in all the following ways except:

The physical design stage of database development:

To solve the problems encountered with the file processing approach, the _______________ management approach was conceived. It is the foundation of modern methods of managing organizational data.

DBMS packages play a major role in application development.

In all information systems, data resources must be organized and structured in some logical manner, so that they can be:

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

Foundations of Information Systems in Business

Competing With Information Technology

Computer Hardware

Computer Software

Telecommunications and Networks

E-Business Systems

Business Across the Enterprise

E-Commerce Systems

Supporting Decision Making

Businessit Strategies for Development

Implementing Businessit Solutions

Security and Ethical Challenges

Enterprise and Global Management of Information Technology

Filters

Exam 5: Data Resource Management

Fixed-length records contain:

Which of the following is true of data marts?

The primary challenge of a distributed database is:

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

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

Database administrators and designers work with corporate and end user management to develop an _______________ model that defines the basic business process of the enterprise.

When independent of any other files related to it, a single table is referred to as a(n):

A DBMS query language is designed to:

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

One drawback to the database duplication process is that no changes can ever be made to any database other than the master. Otherwise, local changes will be overwritten during the duplication process.

Early mainframe DBMS packages used the _______________ structure, in which all records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

_______________ databases have become the most popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.

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

A data warehouse contains data that have been processed in all the following ways except:

The physical design stage of database development:

To solve the problems encountered with the file processing approach, the _______________ management approach was conceived. It is the foundation of modern methods of managing organizational data.

DBMS packages play a major role in application development.

In all information systems, data resources must be organized and structured in some logical manner, so that they can be:

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

Foundations of Information Systems in Business

Competing With Information Technology

Computer Hardware

Computer Software

Telecommunications and Networks

E-Business Systems

Business Across the Enterprise

E-Commerce Systems

Supporting Decision Making

Businessit Strategies for Development

Implementing Businessit Solutions

Security and Ethical Challenges

Enterprise and Global Management of Information Technology

Filters