Question 1

In place of application server software to allow a Web server to communicate with a back-end database,you can use

Accepted Answer

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

Question 2

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 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

DBMS have a data definition capability to specify the structure of the content of the database.

Accepted Answer

A) True 
 B)False

Question 6

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Accepted Answer

A) Batch processing 
B) Data redundancy 
C) Data independence 
D) Online processing 
E) Data quality 
A) Batch processing 
B) Data redundancy 
C) Data independence 
D) Online processing 
E) Data quality

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called

Accepted Answer

A) data auditing. 
B) defragmentation. 
C) data scrubbing. 
D) data optimization. 
E) data normalization. 
A) data auditing. 
B) defragmentation. 
C) data scrubbing. 
D) data optimization. 
E) data normalization.

Question 9

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

Accepted Answer

Data redundancy occurs when different di

Question 10

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

Question 11

Databases record information about general categories of information referred to as entities.

Accepted Answer

A) True 
 B)False

Question 12

The coupling of data with the software programs that manipulate the data,such that changes in programs requires changes to the data,is called program-data dependence.

Accepted Answer

A) True 
 B)False

Question 13

OLAP is a tool for enabling

Accepted Answer

A) users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B) users to view both logical and physical views of data. 
C) programmers to quickly diagram data relationships. 
D) programmers to normalize data. 
E) users to quickly generate summary reports. 
A) users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B) users to view both logical and physical views of data. 
C) programmers to quickly diagram data relationships. 
D) programmers to normalize data. 
E) users to quickly generate summary reports.

Question 14

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

A physical view shows data as it is actually organized and structured on the data storage media.

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

In a relational database,the three basic operations used to develop useful sets of data are

Accepted Answer

A) select,project,and where. 
B) select,join,and where. 
C) select,project,and join. 
D) where,from,and join. 
E) where,find,and select. 
A) select,project,and where. 
B) select,join,and where. 
C) select,project,and join. 
D) where,from,and join. 
E) where,find,and select.

Question 20

The traditional file environment does not typically have a problem with

Accepted Answer

A) data inconsistency. 
B) program-data independence. 
C) lack of flexibility in creating ad-hoc reports. 
D) poor security. 
E) data sharing. 
A) data inconsistency. 
B) program-data independence. 
C) lack of flexibility in creating ad-hoc reports. 
D) poor security. 
E) data sharing.

In place of application server software to allow a Web server to communicate with a back-end database,you can use

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

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

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

DBMS have a data definition capability to specify the structure of the content of the database.

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

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

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called

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?

Databases record information about general categories of information referred to as entities.

The coupling of data with the software programs that manipulate the data,such that changes in programs requires changes to the data,is called program-data dependence.

OLAP is a tool for enabling

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

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

The data dictionary serves as an important data management tool by

A physical view shows data as it is actually organized and structured on the data storage media.

Microsoft SQL Server is a(n)

In a relational database,the three basic operations used to develop useful sets of data are

The traditional file environment does not typically have a problem with

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 place of application server software to allow a Web server to communicate with a back-end database,you can use

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

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

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

DBMS have a data definition capability to specify the structure of the content of the database.

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

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

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called

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?

Databases record information about general categories of information referred to as entities.

The coupling of data with the software programs that manipulate the data,such that changes in programs requires changes to the data,is called program-data dependence.

OLAP is a tool for enabling

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

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

The data dictionary serves as an important data management tool by

A physical view shows data as it is actually organized and structured on the data storage media.

Microsoft SQL Server is a(n)

In a relational database,the three basic operations used to develop useful sets of data are

The traditional file environment does not typically have a problem with

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