Question 1

The most prominent data manipulation language today is

Accepted Answer

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

Question 2

A traditional file system can deliver routine scheduled reports after extensive programming efforts,but it cannot deliver ad hoc reports or respond to unanticipated information requirements in a timely fashion.

Accepted Answer

A) True 
 B)False  True

Question 3

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Accepted Answer

Product databases could be made available to customers for greater convenience and ordering online.Databases could be used to track customer preferences and to help anticipate customer desires.Sales databases could also help clients such as toy stores anticipate when they would need to re-supply,providing an additional service.Data mining,Web mining,and sentiment analysis of big data could help anticipate trends in sales or other factors to help determine new services and products to sell to clients.

Question 4

You have been hired by a national furniture leasing company to implement its first business intelligence systems and infrastructure.To prepare for your initial report,describe the types of data in their firm they can use to support business intelligence and the systems that you will implement to support both their power users and casual users,and explain how these systems or tools work together.

Accepted Answer

All types of data can be used for their

Question 5

To analyze unstructured data,such as memos and legal cases,you would use ________ tools.

Accepted Answer

The answer of To analyze unstructured data,such as memos and...

Question 6

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

Accepted Answer

A) True 
 B)False

Question 7

A ________________________________ is software that permits an organization to centralize data,manage them efficiently,and provide access to the stored data by application programs.

Accepted Answer

Database m

Question 8

Because HTML was designed as a cross-platform language,it is the preferred method of communicating with back-end databases.

Accepted Answer

A) True 
 B)False

Question 9

__________________ refers to the coupling of data stored in files and the specific programs required to update and maintain those files so that changes in programs require changes to the data.

Accepted Answer

Program-da

Question 10

Duplicate data in multiple data files is called data ________.

Accepted Answer

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

Question 11

The confusion created by ________ makes it difficult for companies to create customer relationship management,supply chain management,or enterprise systems that integrate data from different sources.

Accepted Answer

A)  batch processing 
B)  data redundancy 
C)  data independence 
D)  online processing 
A)  batch processing 
B)  data redundancy 
C)  data independence 
D)  online processing

Question 12

The most popular type of DBMS today for PCs as well as for larger computers and mainframes is the ____________________________.

Accepted Answer

A)  relational DBMS 
B)  relational DMBS 
C)  rational DBMS 
D)  rational DMBS 
A)  relational DBMS 
B)  relational DMBS 
C)  rational DBMS 
D)  rational DMBS

Question 13

Microsoft SQL Server is a(n)

Accepted Answer

A)  DBMS for small handheld computing devices. 
B)  Internet DBMS. 
C)  desktop relational DBMS. 
D)  DBMS for midrange computers. 
A)  DBMS for small handheld computing devices. 
B)  Internet DBMS. 
C)  desktop relational DBMS. 
D)  DBMS for midrange computers.

Question 14

DBMS have a(n)________ capability to specify the structure of the Knowledge of the database.

Accepted Answer

The answer of DBMS have a(n)________ capability to specify the...

Question 15

The logical view

Accepted Answer

A)  shows how data are organized and structured on the storage media. 
B)  presents an entry screen to the user. 
C)  allows the creation of supplementary reports. 
D)  presents data as they would be perceived by end users. 
A)  shows how data are organized and structured on the storage media. 
B)  presents an entry screen to the user. 
C)  allows the creation of supplementary reports. 
D)  presents data as they would be perceived by end users.

Question 16

A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

Accepted Answer

A) True 
 B)False

Question 17

A database is a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant data.

Accepted Answer

A) True 
 B)False

Question 18

A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy.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 
A)  text mining tools 
B)  sentiment analysis software 
C)  Web usage mining technologies 
D)  data mining software for identifying associations

Question 19

The tool that enables users to view the same data in different ways using multiple dimensions is

Accepted Answer

A)  predictive analysis. 
B)  SQL. 
C)  OLAP. 
D)  data mining. 
A)  predictive analysis. 
B)  SQL. 
C)  OLAP. 
D)  data mining.

Question 20

OLAP is used for multidimensional data analysis.

Accepted Answer

A) True 
 B)False

The most prominent data manipulation language today is

A traditional file system can deliver routine scheduled reports after extensive programming efforts,but it cannot deliver ad hoc reports or respond to unanticipated information requirements in a timely fashion.

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

To analyze unstructured data,such as memos and legal cases,you would use ________ tools.

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

A ________________________________ is software that permits an organization to centralize data,manage them efficiently,and provide access to the stored data by application programs.

Because HTML was designed as a cross-platform language,it is the preferred method of communicating with back-end databases.

__________________ refers to the coupling of data stored in files and the specific programs required to update and maintain those files so that changes in programs require changes to the data.

Duplicate data in multiple data files is called data ________.

The confusion created by ________ makes it difficult for companies to create customer relationship management,supply chain management,or enterprise systems that integrate data from different sources.

The most popular type of DBMS today for PCs as well as for larger computers and mainframes is the ____________________________.

Microsoft SQL Server is a(n)

DBMS have a(n)________ capability to specify the structure of the Knowledge of the database.

The logical view

A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

A database is a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant data.

A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy.Which of the following tools would you use to analyze this data?

The tool that enables users to view the same data in different ways using multiple dimensions is

OLAP is used for multidimensional data analysis.

Information Systems in Business Today

How Businesses Use Information Systems

Information Systems organizations and Strategy

Social ethical and Legal Issues in the Digital Firm

It Infrastructure and Emerging Technologies

Telecommunications the Internet and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management business Value and Managing Change

Managing Global Systems

Filters

Exam 6: Databases and Information Management

The most prominent data manipulation language today is

A traditional file system can deliver routine scheduled reports after extensive programming efforts,but it cannot deliver ad hoc reports or respond to unanticipated information requirements in a timely fashion.

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

To analyze unstructured data,such as memos and legal cases,you would use ________ tools.

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

A ________________________________ is software that permits an organization to centralize data,manage them efficiently,and provide access to the stored data by application programs.

Because HTML was designed as a cross-platform language,it is the preferred method of communicating with back-end databases.

__________________ refers to the coupling of data stored in files and the specific programs required to update and maintain those files so that changes in programs require changes to the data.

Duplicate data in multiple data files is called data ________.

The confusion created by ________ makes it difficult for companies to create customer relationship management,supply chain management,or enterprise systems that integrate data from different sources.

The most popular type of DBMS today for PCs as well as for larger computers and mainframes is the ____________________________.

Microsoft SQL Server is a(n)

DBMS have a(n)________ capability to specify the structure of the Knowledge of the database.

The logical view

A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

A database is a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant data.

A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy.Which of the following tools would you use to analyze this data?

The tool that enables users to view the same data in different ways using multiple dimensions is

OLAP is used for multidimensional data analysis.

Information Systems in Business Today

How Businesses Use Information Systems

Information Systems organizations and Strategy

Social ethical and Legal Issues in the Digital Firm

It Infrastructure and Emerging Technologies

Telecommunications the Internet and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management business Value and Managing Change

Managing Global Systems

Filters