Question 1

In data mining,which of the following involves events linked over time?

Accepted Answer

A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting 
A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting

Question 2

In-memory computing relies primarily on a computer (RAM)for data storage.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

A field identified in a table as holding the unique identifier of the table's records is called the:

Accepted Answer

A) primary key. 
B) key field. 
C) primary field. 
D) unique ID. 
E) primary entity. 
A) primary key. 
B) key field. 
C) primary field. 
D) unique ID. 
E) primary entity.

Question 5

Which of the following is a grouping of characters into a word,a group of words,or a complete number?

Accepted Answer

A) File 
B) Table 
C) Entity 
D) Field 
E) Tuple 
A) File 
B) Table 
C) Entity 
D) Field 
E) Tuple

Question 6

A schematic of the entire database that describes the relationships in a database is called a(n):

Accepted Answer

A) data dictionary. 
B) intersection relationship diagram. 
C) entity-relationship diagram. 
D) data definition diagram. 
E) data analysis table. 
A) data dictionary. 
B) intersection relationship diagram. 
C) entity-relationship diagram. 
D) data definition diagram. 
E) data analysis table.

Question 7

Which of the following is a DBMS for desktop computers?

Accepted Answer

A) DB2 
B) Oracle Database 
C) Microsoft SQL Server 
D) Microsoft Access 
E) Microsoft Exchange 
A) DB2 
B) Oracle Database 
C) Microsoft SQL Server 
D) Microsoft Access 
E) Microsoft Exchange

Question 8

You can use OLAP to perform multidimensional data analysis.

Accepted Answer

A) True 
 B)False

Question 9

OLAP is unable to manage and handle queries with very large sets of data.

Accepted Answer

A) True 
 B)False

Question 10

A household appliances manufacturer has hired you to help analyze its social media datasets to determine which of its 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 mining technologies 
D) Data mining software 
E) Data governance software 
A) Text mining tools 
B) Sentiment analysis software 
C) Web mining technologies 
D) Data mining software 
E) Data governance software

Question 11

Which of the following best illustrates the relationship between entities and attributes?

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 12

Data mining allows users to:

Accepted Answer

A) quickly compare transaction data gathered over many years. 
B) find hidden relationships in data. 
C) obtain online answers to ad-hoc questions in a rapid amount of time. 
D) summarize massive amounts of data into much smaller,traditional reports. 
E) access the vast amounts of data in a data warehouse. 
A) quickly compare transaction data gathered over many years. 
B) find hidden relationships in data. 
C) obtain online answers to ad-hoc questions in a rapid amount of time. 
D) summarize massive amounts of data into much smaller,traditional reports. 
E) access the vast amounts of data in a data warehouse.

Question 13

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 14

Explain what the term big data refers to.What benefits does it have,and what challenges does it pose?

Accepted Answer

The term big data is used to describe da

Question 15

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

Accepted Answer

A) CGI 
B) HTML 
C) Java 
D) SQL 
E) NoSQL 
A) CGI 
B) HTML 
C) Java 
D) SQL 
E) NoSQL

Question 16

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Accepted Answer

A) True 
 B)False

Question 17

CGI is a DBMS programming language that end users and programmers use to manipulate data in the database.

Accepted Answer

A) True 
 B)False

Question 18

Microsoft SQL Server is a(n):

Accepted Answer

A) DBMS for both desktops and mobile devices. 
B) Internet DBMS. 
C) desktop relational DBMS. 
D) DBMS for midrange computers. 
E) DBMS for mobile devices. 
A) DBMS for both desktops and mobile devices. 
B) Internet DBMS. 
C) desktop relational DBMS. 
D) DBMS for midrange computers. 
E) DBMS for mobile devices.

Question 19

Which of the following occurs when the same attribute in related data files has different values?

Accepted Answer

A) Data redundancy 
B) Data duplication 
C) Data dependence 
D) Data discrepancy 
E) Data inconsistency 
A) Data redundancy 
B) Data duplication 
C) Data dependence 
D) Data discrepancy 
E) Data inconsistency

Question 20

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

Accepted Answer

Data redundancy occurs when different di

In data mining,which of the following involves events linked over time?

In-memory computing relies primarily on a computer (RAM)for data storage.

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

A field identified in a table as holding the unique identifier of the table's records is called the:

Which of the following is a grouping of characters into a word,a group of words,or a complete number?

A schematic of the entire database that describes the relationships in a database is called a(n):

Which of the following is a DBMS for desktop computers?

You can use OLAP to perform multidimensional data analysis.

OLAP is unable to manage and handle queries with very large sets of data.

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

Which of the following best illustrates the relationship between entities and attributes?

Data mining allows users to:

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Explain what the term big data refers to.What benefits does it have,and what challenges does it pose?

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

CGI is a DBMS programming language that end users and programmers use to manipulate data in the database.

Microsoft SQL Server is a(n):

Which of the following occurs when the same attribute in related data files has different values?

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

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 data mining,which of the following involves events linked over time?

In-memory computing relies primarily on a computer (RAM)for data storage.

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

A field identified in a table as holding the unique identifier of the table's records is called the:

Which of the following is a grouping of characters into a word,a group of words,or a complete number?

A schematic of the entire database that describes the relationships in a database is called a(n):

Which of the following is a DBMS for desktop computers?

You can use OLAP to perform multidimensional data analysis.

OLAP is unable to manage and handle queries with very large sets of data.

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

Which of the following best illustrates the relationship between entities and attributes?

Data mining allows users to:

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Explain what the term big data refers to.What benefits does it have,and what challenges does it pose?

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

CGI is a DBMS programming language that end users and programmers use to manipulate data in the database.

Microsoft SQL Server is a(n):

Which of the following occurs when the same attribute in related data files has different values?

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

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