Question 1

In large organizations, database design and management is handled by a _____. ​

Accepted Answer

A)  database administrator 
B)  database evaluator 
C)  database synchronizer 
D)  database developer 
A)  database administrator 
B)  database evaluator 
C)  database synchronizer 
D)  database developer

Question 2

In a relational database model, the rows are called _____.

Accepted Answer

A)  tuples 
B)  attributes 
C)  branches 
D)  roots 
A)  tuples 
B)  attributes 
C)  branches 
D)  roots

Question 3

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Accepted Answer

A) True 
 B)False

Question 4

Disks are sequential access devices, whereas tapes are random access devices.

Accepted Answer

A) True 
 B)False

Question 5

Explain the function of the data definition component of a database management system.

Accepted Answer

Answers will vary.The data definition co

Question 6

A data hierarchy_____is the structure and organization of data, which involves fields, records, and files. ​

Accepted Answer

A)  data hierarchy 
B)  data mart 
C)  data warehouse 
D)  data mine 
A)  data hierarchy 
B)  data mart 
C)  data warehouse 
D)  data mine

Question 7

Data warehouses are sometimes called hypercubes because they _____.

Accepted Answer

A)  are function oriented 
B)  store multidimensional data 
C)  capture raw transaction data 
D)  manage transactions 
A)  are function oriented 
B)  store multidimensional data 
C)  capture raw transaction data 
D)  manage transactions

Question 8

Which of the following statements is true of distributed databases?

Accepted Answer

A)  They store data on one central server in an organization. 
B)  They are limited by the data's physical location. 
C)  In distributed databases, local storage of data increases response time. 
D)  In distributed databases, local storage of data increases communication costs. 
A)  They store data on one central server in an organization. 
B)  They are limited by the data's physical location. 
C)  In distributed databases, local storage of data increases response time. 
D)  In distributed databases, local storage of data increases communication costs.

Question 9

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Accepted Answer

Answers will vary.The fragmentation appr

Question 10

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Accepted Answer

A)  Data structure 
B)  Schema diagrams 
C)  Integrity rules 
D)  File procedure 
A)  Data structure 
B)  Schema diagrams 
C)  Integrity rules 
D)  File procedure

Question 11

In a _____, the relationships among records form a treelike structure. ​

Accepted Answer

A)  hierarchical model 
B)  relational model 
C)  network model 
D)  spiral model 
A)  hierarchical model 
B)  relational model 
C)  network model 
D)  spiral model

Question 12

In the context of data models, relationships among records in a hierarchical model are called _____.

Accepted Answer

A)  nodes 
B)  branches 
C)  roots 
D)  segments 
A)  nodes 
B)  branches 
C)  roots 
D)  segments

Question 13

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Accepted Answer

A)  predictive modeling 
B)  dashboards 
C)  query reports 
D)  application generators 
A)  predictive modeling 
B)  dashboards 
C)  query reports 
D)  application generators

Question 14

Which of the following is an advantage of a database over a flat file system?

Accepted Answer

A)  Hardware and software start-up costs are low when using a database. 
B)  A database is simple and easy to design. 
C)  Programs and data are interdependent in a database. 
D)  A database uses more sophisticated security measures. 
A)  Hardware and software start-up costs are low when using a database. 
B)  A database is simple and easy to design. 
C)  Programs and data are interdependent in a database. 
D)  A database uses more sophisticated security measures.

Question 15

Describe the features and benefits of an object-oriented database.

Accepted Answer

Answers will vary.Like object-oriented p

Question 16

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

Accepted Answer

A) True 
 B)False

Question 17

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Accepted Answer

A) True 
 B)False

Question 18

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Accepted Answer

A) True 
 B)False

Question 19

In comparison with flat file systems, databases:

Accepted Answer

A)  minimize data redundancy. 
B)  are easier to design. 
C)  have less sophisticated security measures. 
D)  require more storage space. 
A)  minimize data redundancy. 
B)  are easier to design. 
C)  have less sophisticated security measures. 
D)  require more storage space.

Question 20

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

Accepted Answer

A)  The optimization approach 
B)  The allocation approach 
C)  The encapsulation approach 
D)  The normalization approach 
A)  The optimization approach 
B)  The allocation approach 
C)  The encapsulation approach 
D)  The normalization approach

In large organizations, database design and management is handled by a _____.

In a relational database model, the rows are called _____.

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Disks are sequential access devices, whereas tapes are random access devices.

Explain the function of the data definition component of a database management system.

A data hierarchy_____is the structure and organization of data, which involves fields, records, and files.

Data warehouses are sometimes called hypercubes because they _____.

Which of the following statements is true of distributed databases?

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

In a _____, the relationships among records form a treelike structure.

In the context of data models, relationships among records in a hierarchical model are called _____.

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Which of the following is an advantage of a database over a flat file system?

Describe the features and benefits of an object-oriented database.

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

In comparison with flat file systems, databases:

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

The Internet, Intranets, and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends, Technologies, and Applications

Filters

Exam 3: Database Systems, Data Warehouses and Data Marts

In large organizations, database design and management is handled by a _____. ​

In a relational database model, the rows are called _____.

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Disks are sequential access devices, whereas tapes are random access devices.

Explain the function of the data definition component of a database management system.

A data hierarchy_____is the structure and organization of data, which involves fields, records, and files. ​

Data warehouses are sometimes called hypercubes because they _____.

Which of the following statements is true of distributed databases?

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

In a _____, the relationships among records form a treelike structure. ​

In the context of data models, relationships among records in a hierarchical model are called _____.

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Which of the following is an advantage of a database over a flat file system?

Describe the features and benefits of an object-oriented database.

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

In comparison with flat file systems, databases:

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

The Internet, Intranets, and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends, Technologies, and Applications

Filters

In large organizations, database design and management is handled by a _____.

A data hierarchy_____is the structure and organization of data, which involves fields, records, and files.

In a _____, the relationships among records form a treelike structure.