Question 1

Data mining is a tool for allowing 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 2

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

A data definition capability to specify

Question 3

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 4

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 5

Big data does not refer to

Accepted Answer

A) datasets with fewer than a billion records. 
B) datasets with unstructured data. 
C) machine-generated data (i.e.from sensors). 
D) data created by social media (i.e.tweets,Facebook Likes). 
E) data from Web traffic. 
A) datasets with fewer than a billion records. 
B) datasets with unstructured data. 
C) machine-generated data (i.e.from sensors). 
D) data created by social media (i.e.tweets,Facebook Likes). 
E) data from Web traffic.

Question 6

A database record is a grouping of characters into a word,a group of words,or a complete number.

Accepted Answer

A) True 
 B)False

Question 7

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

Accepted Answer

A) True 
 B)False

Question 8

With in-memory computing,a computer's primary memory (RAM)is used for processing.

Accepted Answer

A) True 
 B)False

Question 9

Data ________ occurs when the same data is duplicated in multiple files of a database.

Accepted Answer

A) redundancy 
B) repetition 
C) independence 
D) partitions 
E) discrepancy 
A) redundancy 
B) repetition 
C) independence 
D) partitions 
E) discrepancy

Question 10

A field identified in a record as holding the unique identifier for that record is called the

Accepted Answer

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

Question 11

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 12

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Accepted Answer

Data mining is one of the data analysis

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is not a DBMS for midrange computers?

Accepted Answer

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

Question 15

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 16

DBMSs typically include report-generating tools in order to

Accepted Answer

A) retrieve and display data. 
B) display data in an easier-to-read format. 
C) display data in graphs. 
D) perform predictive analysis. 
E) analyse the database's performance. 
A) retrieve and display data. 
B) display data in an easier-to-read format. 
C) display data in graphs. 
D) perform predictive analysis. 
E) analyse the database's performance.

Question 17

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 18

Every record in a file should contain at least one key field.

Accepted Answer

A) True 
 B)False

Question 19

In data mining,the technique of predicting uses a series of existing values to determine what other future values will be.

Accepted Answer

A) True 
 B)False

Question 20

The logical and physical views of data are separated in a DBMS.

Accepted Answer

A) True 
 B)False

Data mining is a tool for allowing users to

List and describe three main capabilities or tools of a DBMS.

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

The logical view of a database

Big data does not refer to

A database record is a grouping of characters into a word,a group of words,or a complete number.

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

With in-memory computing,a computer's primary memory (RAM)is used for processing.

Data ________ occurs when the same data is duplicated in multiple files of a database.

A field identified in a record as holding the unique identifier for that record is called the

Data cleansing not only corrects errors but also

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

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

Which of the following is not a DBMS for midrange computers?

The relationship between entities and attributes is best illustrated by

DBMSs typically include report-generating tools in order to

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

Every record in a file should contain at least one key field.

In data mining,the technique of predicting uses a series of existing values to determine what other future values will be.

The logical and physical views of data are separated in a DBMS.

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

Data mining is a tool for allowing users to

List and describe three main capabilities or tools of a DBMS.

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

The logical view of a database

Big data does not refer to

A database record is a grouping of characters into a word,a group of words,or a complete number.

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

With in-memory computing,a computer's primary memory (RAM)is used for processing.

Data ________ occurs when the same data is duplicated in multiple files of a database.

A field identified in a record as holding the unique identifier for that record is called the

Data cleansing not only corrects errors but also

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

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

Which of the following is not a DBMS for midrange computers?

The relationship between entities and attributes is best illustrated by

DBMSs typically include report-generating tools in order to

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

Every record in a file should contain at least one key field.

In data mining,the technique of predicting uses a series of existing values to determine what other future values will be.

The logical and physical views of data are separated in a DBMS.

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