Question 1

In a relational database, a record is referred to in technical terms as a(n)

Accepted Answer

A)  tuple. 
B)  row. 
C)  entity. 
D)  field. 
E)  key. 
A)  tuple. 
B)  row. 
C)  entity. 
D)  field. 
E)  key.

Question 2

You can manipulate data on a Web server by using a CGI script.

Accepted Answer

A) True 
 B)False

Question 3

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

Accepted Answer

A) True 
 B)False

Question 4

A data warehouse is composed of

Accepted Answer

A)  historical data from legacy systems. 
B)  current data. 
C)  internal and external data sources. 
D)  historic and current internal data. 
E)  historic external data. 
A)  historical data from legacy systems. 
B)  current data. 
C)  internal and external data sources. 
D)  historic and current internal data. 
E)  historic external data.

Question 5

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Accepted Answer

A) True 
 B)False

Question 6

The relationship between entities and attributes is best illustrated by

Accepted Answer

A)  the entity CUSTOMER with the attribute PRODUCT. 
B)  the entity CUSTOMER with the attribute PURCHASE. 
C)  the entity PRODUCT with the attribute PURCHASE. 
D)  the entity PRODUCT with the attribute CUSTOMER. 
E)  the entity PURCHASE with the attribute CUSTOMER. 
A)  the entity CUSTOMER with the attribute PRODUCT. 
B)  the entity CUSTOMER with the attribute PURCHASE. 
C)  the entity PRODUCT with the attribute PURCHASE. 
D)  the entity PRODUCT with the attribute CUSTOMER. 
E)  the entity PURCHASE with the attribute CUSTOMER.

Question 7

The logical view of a database

Accepted Answer

A)  displays the organization and structure of data on the physical storage media. 
B)  includes a digital dashboard. 
C)  allows the creation of supplementary reports. 
D)  enables users to manipulate the logical structure of the database. 
E)  presents data as they would be perceived by end users. 
A)  displays the organization and structure of data on the physical storage media. 
B)  includes a digital dashboard. 
C)  allows the creation of supplementary reports. 
D)  enables users to manipulate the logical structure of the database. 
E)  presents data as they would be perceived by end users.

Question 8

A(n) ________ is an example of non-digital data storage that is comparable to a database.

Accepted Answer

A)  library card catalog 
B)  cash register receipt 
C)  doctor's office invoice 
D)  list of sales totals on a spreadsheet 
E)  schedule of due dates on a project outline 
A)  library card catalog 
B)  cash register receipt 
C)  doctor's office invoice 
D)  list of sales totals on a spreadsheet 
E)  schedule of due dates on a project outline

Question 9

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Accepted Answer

A) True 
 B)False

Question 10

A(n) ________ is a characteristic or quality that describes a database entity.

Accepted Answer

A)  field 
B)  tuple 
C)  key field 
D)  attribute 
E)  relationship 
A)  field 
B)  tuple 
C)  key field 
D)  attribute 
E)  relationship

Question 11

The data dictionary serves as an important data management tool by

Accepted Answer

A)  assigning attributes to the data. 
B)  creating an inventory of the data elements contained in the database. 
C)  presenting data as end users or business specialists would perceive them. 
D)  maintaining data in updated form. 
E)  providing a guide to database terms and settings. 
A)  assigning attributes to the data. 
B)  creating an inventory of the data elements contained in the database. 
C)  presenting data as end users or business specialists would perceive them. 
D)  maintaining data in updated form. 
E)  providing a guide to database terms and settings.

Question 12

Data cleansing not only corrects errors but also

Accepted Answer

A)  establishes logical relationships between data. 
B)  structures data. 
C)  normalizes data. 
D)  removes duplicate data. 
E)  enforces consistency among different sets of data. 
A)  establishes logical relationships between data. 
B)  structures data. 
C)  normalizes data. 
D)  removes duplicate data. 
E)  enforces consistency among different sets of data.

Question 13

What are the differences between data mining and OLAP?
 When would you advise a company to use OLAP?

Accepted Answer

Data mining uncovers hidden relationship

Question 14

The most prominent data manipulation language today is

Accepted Answer

A)  Access. 
B)  DB2. 
C)  SQL. 
D)  Crystal Reports. 
E)  NoSQL. 
A)  Access. 
B)  DB2. 
C)  SQL. 
D)  Crystal Reports. 
E)  NoSQL.

Question 15

To perform multidimensional data analysis, you would use OLAP.

Accepted Answer

A) True 
 B)False

Question 16

In a table for customers, the information about a single customer would reside in a single

Accepted Answer

A)  field. 
B)  row. 
C)  column. 
D)  table. 
E)  entity. 
A)  field. 
B)  row. 
C)  column. 
D)  table. 
E)  entity.

Question 17

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

Accepted Answer

A) True 
 B)False

Question 18

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

Accepted Answer

A)  information policy. 
B)  data definition file. 
C)  data quality audit. 
D)  data governance policy. 
E)  data policy. 
A)  information policy. 
B)  data definition file. 
C)  data quality audit. 
D)  data governance policy. 
E)  data policy.

Question 19

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

Data redundancy occurs when different di

Question 20

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Accepted Answer

A)  text mining tools 
B)  sentiment analysis software 
C)  Web usage mining technologies 
D)  data mining software for identifying associations 
E)  data mining software for forecasting 
A)  text mining tools 
B)  sentiment analysis software 
C)  Web usage mining technologies 
D)  data mining software for identifying associations 
E)  data mining software for forecasting

In a relational database, a record is referred to in technical terms as a(n)

You can manipulate data on a Web server by using a CGI script.

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

A data warehouse is composed of

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

The relationship between entities and attributes is best illustrated by

The logical view of a database

A(n) ________ is an example of non-digital data storage that is comparable to a database.

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

A(n) ________ is a characteristic or quality that describes a database entity.

The data dictionary serves as an important data management tool by

Data cleansing not only corrects errors but also

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

The most prominent data manipulation language today is

To perform multidimensional data analysis, you would use OLAP.

In a table for customers, the information about a single customer would reside in a single

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

List at least three conditions that contribute to data redundancy and inconsistency.

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence: Databases and Information Management

In a relational database, a record is referred to in technical terms as a(n)

You can manipulate data on a Web server by using a CGI script.

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

A data warehouse is composed of

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

The relationship between entities and attributes is best illustrated by

The logical view of a database

A(n) ________ is an example of non-digital data storage that is comparable to a database.

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

A(n) ________ is a characteristic or quality that describes a database entity.

The data dictionary serves as an important data management tool by

Data cleansing not only corrects errors but also

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

The most prominent data manipulation language today is

To perform multidimensional data analysis, you would use OLAP.

In a table for customers, the information about a single customer would reside in a single

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

List at least three conditions that contribute to data redundancy and inconsistency.

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters