Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The specialized language programmers use to add and change data in the database is called

Accepted Answer

A)  a data access language. 
B)  a data manipulation language. 
C)  structured query language. 
D)  a data definition language. 
E)  a DBMS. 
A)  a data access language. 
B)  a data manipulation language. 
C)  structured query language. 
D)  a data definition language. 
E)  a DBMS.

Question 4

You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of

Accepted Answer

A)  identifying associations. 
B)  identifying clusters. 
C)  identifying sequences. 
D)  classification. 
E)  forecasting. 
A)  identifying associations. 
B)  identifying clusters. 
C)  identifying sequences. 
D)  classification. 
E)  forecasting.

Question 5

The join operation

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  identifies the table from which the columns will be selected. 
C)  creates a subset consisting of columns in a table. 
D)  organizes elements into segments. 
E)  creates a subset consisting of rows in a table. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  identifies the table from which the columns will be selected. 
C)  creates a subset consisting of columns in a table. 
D)  organizes elements into segments. 
E)  creates a subset consisting of rows in a table.

Question 6

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 7

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

Accepted Answer

Student answers will vary, but should in

Question 8

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing?
 Which of these fields might be in use in other databases used by the company?

Accepted Answer

Author first name, author last name, aut

Question 9

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 10

The special organizational function whose responsibilities include physical database design and maintenance is called

Accepted Answer

A)  data administration. 
B)  database administration. 
C)  information policy administration. 
D)  data auditing. 
E)  database management. 
A)  data administration. 
B)  database administration. 
C)  information policy administration. 
D)  data auditing. 
E)  database management.

Question 11

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 12

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 13

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 availabl

Question 14

________ 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 15

The project operation

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  organizes elements into segments. 
D)  identifies the table from which the columns will be selected. 
E)  creates a subset consisting of rows in a table. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  organizes elements into segments. 
D)  identifies the table from which the columns will be selected. 
E)  creates a subset consisting of rows in a table.

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

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 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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.

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

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

The specialized language programmers use to add and change data in the database is called

The join operation

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?

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

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

The special organizational function whose responsibilities include physical database design and maintenance is called

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

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

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

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

The project operation

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

DBMSs typically include report-generating tools in order to

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

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

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

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

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

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

The specialized language programmers use to add and change data in the database is called

The join operation

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?

The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

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

The special organizational function whose responsibilities include physical database design and maintenance is called

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

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

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

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

The project operation

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

DBMSs typically include report-generating tools in order to

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

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

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

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